how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 12892 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / narayana.3ds
R.D Stage remove the duplicates every one knows but u can
find max salary......
Give the key of salary order by descending other
option u can put=first
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
why do u need the IOS upgradation in a FC switch
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is job control?
What is the difference between server job and parallel jobs?
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.
In Datastage, how you can fix the truncated data error?
What are stage variables, derivations and constants?
how to write server Routine coding?
What is the difference between datastage and datastage tx?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Does datastage support slowly changing dimensions ?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
what is ds administrator used for?
EXPLAIN SCD
What is oci?
