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
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
Differentiate between datastage and informatica?
What are the differences between datastage and informatica?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are datastage sequences?
why do u need the IOS upgradation in a FC switch
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
How do you reject records in a transformer?
Why do we use link partitioner and link collector in datastage?
Can you explain repository tables in datastage?
how to export or import the jobs in .ISX file
What is quality stage?
Explain entity, attribute and relationship in datastage?
Can you explain players in datastage?
Difference between server jobs & parallel jobs?
Difference between data warehousing and olap?