how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 12888 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / phani kumar
By using Sort stage, sort the data in Descending order, then
use remove duplicates stage, set option as first occurrence
of records. Then we will get max sal record first.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how to run a sequential file stage in parallel if the stage is used on the TARGET side
On which Dimension Table you implemented SCD Type in your Project
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the main features of datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
why do u need the IOS upgradation in a FC switch
What is the command line function to import and export the ds jobs?
How a routine is called in datastage job?
How do y read Sequential file from job control?
How to reverse the string using unix?
Can we use target hash file as a lookup ?
Have you have ever worked in unix environment and why it is useful in datastage?
what are the errors,warnings in datastage
State the difference between an operational datastage and a data warehouse?
What are the different options associated with dsjob command?
