Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 24639 Views
- CTS, I also Faced
- E-Mail Answers
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 importance of the exception activity in datastage?
What are sequencers?
What is oci?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Where the datastage stored his repository?
How do you reject records in a transformer?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Name the different types of Lookups in Datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Difference between server jobs & parallel jobs?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What could be a data source system?
What are routines in datastage?
Where do you see different stages in the designer?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
