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
- 24528 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 are the some differences between 7.x and 8.x version of datastage?
options available in sequence job to run,validate?
What is the method of removing duplicates, without the remove duplicate stage?
What is the difference between datastage and informatica?
Notification Activity
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the use of datastage designer?
What is the difference between datastage and datastage tx?
how can we create rank using datastage?what is the meaning of rank?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how to write server Routine coding?
Can you explain repository tables in datastage?
What are some prerequisites for datastage?
How do u convert the columns to rows in datastage?
Explain entity, attribute and relationship in datastage?
