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
- 24273 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 to clean the datastage repository?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the difference between account and directory options ?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is ibm datastage flow designer?
What are the enhancements made in datastage 7.5 compare with 7.0?
Is it possible to query a hash file?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Define Job control?
What are the different types of lookups in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what is the use of skid in reporting?
What is quality stage?
Differentiate between validated and Compiled in the Datastage?
