i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
Answer Posted / nish
remove duplicate-> retail last
Alternate MEthod: if there are only two occurences then sort stage-> descending-> remove duplicates
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the processing stages?
What are the different plug-ins stages used in your projects?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
what is the use of skid in reporting?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is process model?
Define project in datastage?
Why do we use link partitioner and link collector in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Explain entity, attribute and relationship in datastage?
What steps should be taken to improve Datastage jobs?
What are routines in datastage? Enlist various types of routines.
What is the difference between Datastage 7.5 and 7.0?
What are the types of hashed files in data stage
What are the components of ascential data stage?