when U have a remove dublicate option in sort stage, why we
have a remove dublicate stage in PX, thought it is
recamended to sort data before using a remove dublicate
stage. I hae been thinking this from days....
Answer Posted / swati
In Remove Duplicate stage you will get only unique records.
In sort Stage you will get both unique and duplicate records based on key change column.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can we create rank using datastage?what is the meaning of rank?
Can you explain engine tier in information server?
Define Merge?
What is difference between join, merge and lookup stage?
How can you write parallel routines in datastage PX?
What is the use of hoursfromtime() function in transformer stage in datastage?
Explain ibm infosphere information server and highlight its main features?
what is the use of surogate key in datastage
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 the project in datastage?
What is ibm datastage?
Name the different types of Lookups in Datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
how many rows sorted in sort stage by default in server jobs