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
- 24608 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
How one source columns or rows to be loaded in to two different tables?
What are the types of containers?
What is ibm datastage?
What are the job parameters?
what is the use of materialized view?
what is the custome stage in datastage? how can we impliment that one? plz tell me
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is data partitioning?
What could be a data source system?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the types of containers and how to create them?
How a source file is populated?
what are the errors,warnings in datastage
What are the steps needed to create a simple basic datastage job?
