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
- 21581 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ramachandra rao
After source use aggregator stage and use option aggregator
type is count and count the records after that use filter in
where clause count>1 ie duplicate records go to one target
and another where clause count=1 ie unique records go to
another target.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the repository tables in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Distinguish between informatica & datastage. Which one would you choose and why?
What is use Array size in datastage
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What could be a data source system?
Give an idea of system variables.
Explain entity, attribute and relationship in datastage?
Could anyone give brief explanation bout datastage admin
sed,awk,head
Lookup constraints
What are the functionalities of link collector?
How do you import and export data into datastage?
How to manage date conversion in Datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
