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 / narasimha rao k

By using Removeduplcate stage in datstage

This stage having avalabel Removeduplicate 1st and last you select last automatically apply to second duplicate data

Is This Answer Correct ?    6 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oci?

846


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

341


What are system variables and sequencers in datastage

602


Difference between in process and inter process?

689


What is ibm datastage?

599






What could be a data source system?

573


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1797


Which commands are used to import and export the datastage jobs?

976


What are the different common services in datastage?

696


How do you remove duplicate values in datastage?

617


What are the processing stages?

638


What is job control?

620


How do you register plug-ins?

594


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1754


What is the process of killing a job in datastage?

581