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
How to read multiple files using a single datastage job if files have the same metadata?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Explain ibm infosphere information server and highlight its main features?
What is the difference between informatica and datastage?
Define Merge?
Describe stream connector?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
what are the errors,warnings in datastage
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
how many rows sorted in sort stage by default in server jobs
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Define oconv () and iconv () functions in datastage?
How many types of sorting methods are available in datastage?