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
- 24230 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 some prerequisites for datastage?
Can you explain repository tables in datastage?
What are iconv and oconv?
What is the difference between in process and inter process?
how to sort two columns in single job in datastage.
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
Define data aggregation?
Differentiate between operational datastage (ods) and data warehouse?
Demonstrate experience in maintaining quality process standards?
What is merge stage?
How do you schedule or monitoring the job?
How to find value from a column in a dataset?
What is the difference between informatica and datastage?
What are the components of datastage?
Define Job control?
