Interested to Buy Any Domain ? << Click Here >> for more details...
i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring
- 13 Answers
- 21010 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / msbharathi
- > Unique
Sq File - > Aggregate - > Transformer |
- > Duplicate
1. Read data in seq file stage.
2. In Aggregate stage group by EID and count the number of rows in Count column
3. In transformer stage create loop condition as @ITERATION<= DSLink6.Count and derivation as EID = EMPNO.
4. In unique output tab use constraint count<=1 and in duplicate output tab use constraint count>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the process of killing a job in datastage?
What is ds designer?
What are the types of containers and how to create them?
What is the difference between orabulk and bcp stages?
What is quality stage?
What is oci?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the sortmerge collector?
What is the use of datastage designer?
table actions available in oracle connector?
which r the connectors used in san?
Differentiate between data file and descriptor file?
What are the repository tables in datastage?
How do you schedule or monitoring the job?
Nls stands for what in datastage?
