how do u capture duplicates through sort & transformer

Answer Posted / harikiran

in transformer stage output properties tab there is a
sorting option if u mention sort option there are two more
operations are there like unique and stable sort. if u
click on uniqu it will restrict the duplicates

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to reverse the string using SQL?

906


How to implement complex jobs in data stage?

624


what is flow of project?

1567


Does datastage support slowly changing dimensions ?

667


Name the different types of Lookups in Datastage?

739






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

672


Difference between sequential file and data set?

658


What are stage variables, derivations and constants?

686


What is datastage engine?

735


what is repositery?

1307


What are the types of hashed files in data stage

658


what is the use of skid in reporting?

1961


Differentiate between odbc and drs stage?

606


Differentiate between validated and Compiled in the Datastage?

658


What are the types of jobs we have in datastage?

682