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 is "fatal error/rdbms code 3996" error?
How many types of stage?
What is the difference between datastage and informatica?
What are system variables and sequencers in datastage
What is the different type of jobs in datastage?
Define oconv () and iconv () functions in datastage?
How to manage date conversion in Datastage?
What is the use of datastage designer?
Explain the importance of surrogate key in data warehousing?
How to perform incremental load in datastage?
what is repositery?
What are the areas of application?
How do u convert the columns to rows in datastage?
What are the types of hashed files in data stage
Nls stands for what in datastage?