Interested to Buy Any Domain ? << Click Here >> for more details...
how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 14723 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / akila
In case an explicit sort stage is used like inteh reply
above, the sort will be done on emp_id(key field) and the
salary. But remove duplicate will be done only on emp_id. I
guess that this might result in a warning like 'sort and
remove duplicates keys do not match'.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is a datastage job?
What is the roundrobin collector?
What is a merge?
client know skid info?
How we can covert server job to a parallel job?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are routines in datastage?
How many Key we can define in remove duplicate stage?
What are iconv and oconv?
Describe the architecture of datastage?
What is the process of killing a job in datastage?
Differentiate between data file and descriptor file?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
