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
- 24852 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 "fatal error/rdbms code 3996" error?
Explain datastage architecture?
What is a merge?
What are the steps needed to create a simple basic datastage job?
How do y read Sequential file from job control?
What is active and passive stage?
How to convert RGB Value to Hexadecimal values in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is a datastage job?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
what is repositery?
How do you register plug-ins?
What are datastage sequences?
How many types of hash files are there?
What are the job parameters?
