How to remove duplicates in transformer stage? in parallel
mode

Answer Posted / satya

run u r job in sequencial mode and sort the source data
then play with stage variable's in Transformer.

because in parallel mode data is partioned .

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is usage analysis in datastage?

821


Can you explain repository tables in datastage?

909


Why we use surrogate key?

701


What are the various kinds of the hash file?

667


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2429






How to perform incremental load in datastage?

675


Why do we use link partitioner and link collector in datastage?

689


What is the differentiate between data file and descriptor file?

869


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3387


What is difference between join, merge and lookup stage?

642


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

666


What are the types of containers and how to create them?

562


What are stage variables, derivations and constants?

678


Highlight the main features of datastage?

619


What are the main differences you have observed between 7.x and 8.x version of datastage?

626