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
Can you explain how could anyone drop the index before loading the data in target in datastage?
Differentiate between datastage and datastage tx?
What are the types of containers in datastage?
How many Key we can define in remove duplicate stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the sortmerge collector?
Name the third party tools that can be used in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Define Merge?
Can you explain players in datastage?
What is ibm datastage flow designer?
how to abort the job its matain duplicates?
how can we create rank using datastage?what is the meaning of rank?