how do u capture duplicates through sort & transformer

Answer Posted / kiran

Hai..,

In sort stage we have one property...its create key change
column.

In Transformer stage ,we have to write if then else
condition.....

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

root tree will find which is server job and which is parallel job?

1653


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1839


Can you explain players in datastage?

968


How a routine is called in datastage job?

837


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3221


what are the devoleper roles in real time? plz tell i am new to datastage....

1882


What is difference between join, merge and lookup stage?

860


Can we use target hash file as a lookup ?

3059


How do you register plug-ins?

776


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1162


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

561


What are the repository tables in datastage?

1062


What are the different type of jobs in datastage?

845


What are the main features of datastage?

919


What are the features of datastage flow designer?

831