I have source file which contains duplicate data,my
requirement is unique data should pass to one file and
duplicate data should pass another file how?
Answer Posted / riyazahamedmohamed
take two links using copystage, of your input file,one is your input file output, another one is for keychange column(using sort stage set the key change column to true) with filter "0" out of transformer, to the look up stage.set the lookup option to continue-reject.you will get the desired output.reject will capture unique records.output file will capture duplicate records.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between validated and compiled in the datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to RD using transformer?
What is datastage engine?
What is the purpose of pivot stage?
how many rows sorted in sort stage by default in server jobs
What is staging variable?
explain about citrix scheduling tool in datastage
What are iconv and oconv?
What is a folder? Difference types of stages?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Notification Activity
What is a ds designer?
What is the flow of loading data into fact & dimensional tables?
Explain how a source file is populated?