How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
Answer Posted / nandhini
Create one dummy key and set the value as 1 for all input
columns and use remove duplicate stage. Here use this dummy
as key and use sorting, partitioning for dummy and company
columns & use sorting (descending) for salary column and in
properties tab, select duplicate to retain as last.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why do you need stage variables?
What is the process of killing a job in datastage?
what is repositery?
How to clean the datastage repository?
describe the Steps to confiure a Qlogic switch
What is ibm datastage flow designer?
Differentiate between datastage and datastage tx?
What is datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the some differences between 7.x and 8.x version of datastage?
in oracle target stage when we use load option and when we use upsert option?
How one source columns or rows to be loaded in to two different tables?
Differentiate between validated and Compiled in the Datastage?
root tree will find which is server job and which is parallel job?
how do u catch bad rows from OCI stage? And what CLI stands for?