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


Please Help Members By Posting Answers For Below Questions

What is "fatal error/rdbms code 3996" error?

658


How many types of stage?

667


What is the difference between datastage and informatica?

606


What are system variables and sequencers in datastage

602


What is the different type of jobs in datastage?

566






Define oconv () and iconv () functions in datastage?

871


How to manage date conversion in Datastage?

632


What is the use of datastage designer?

632


Explain the importance of surrogate key in data warehousing?

706


How to perform incremental load in datastage?

659


what is repositery?

1288


What are the areas of application?

654


How do u convert the columns to rows in datastage?

687


What are the types of hashed files in data stage

636


Nls stands for what in datastage?

724