Can I read Sequence Number and Salary Aggregation Guide on EtoBox?

Sequence Number and Salary Aggregation Guide by SQL INFORMATICA is a document available to read on EtoBox.

What is Sequence Number and Salary Aggregation Guide about?

The document describes transforming input data into two output targets. The input data contains department IDs, employee IDs, and salaries. It is first sorted by department ID and aggregated to find the maximum and minimum salary for each department. The data is then joined back to the original and routed such that the first target contains the highest paid employee per department and the second target contains the lowest paid employee per department.

Author

SQL INFORMATICA

Language

EN