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
- 23090 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 the custome stage in datastage? how can we impliment that one? plz tell me
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
why do u need the IOS upgradation in a FC switch
What is the difference between orabulk and bcp stages?
Distinguish between informatica & datastage. Which one would you choose and why?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Differentiate between operational datastage (ods) and data warehouse?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are routines in datastage?
What are the types of containers in datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
how to write server Routine coding?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
how to export or import the jobs in .ISX file
Could anyone give brief explanation bout datastage admin
