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
- 23261 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / dilip anand k
Its Simple!!
All you have to do is link your source to a Sort Stage.
Sort the data and generate a Key Change column.
Key Change column = ‘1’ represents that the record is
unique while Key Change Column = ‘0’ represents the
duplicates.
Put a Filter stage and filter out the data into two
different outputs based on the generated Key Change Column.
| Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
What is the use of datastage designer?
What is a datastage job?
What is the difference between passive stage and active stage?
What are the different layers in the information server architecture?
Difference between data warehousing and olap?
Distinguish between informatica & datastage. Which one would you choose and why?
How complex jobs are implemented in datstage to improve performance?
whom do you report?
Which algorithm you used for your hashfile?
What all the types of jobs you developed?
What are the areas of application?
What is datastage engine?
What are data elements?
how to add a new records into source?
What are the job parameters?
