how can find maximum salary by using Remove duplicate stage?
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
What is usage analysis in datastage?
Define ds designer?
What is a merge in datastage?
What are the important features of datastage?
Notification Activity
Name the command line functions to import and export the DS jobs?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Define orabulk and bcp stages?
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)
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are the types of hashed files in data stage
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the some differences between 7.x and 8.x version of datastage?
How can one find bugs in job sequence?
What is use Array size in datastage