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
- 20632 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
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How rejected rows are managed in datastage?
Explain how a source file is populated?
Can you explain repository tables in datastage?
Differentiate between Join, Merge and Lookup stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is usage analysis in datastage?
What are datastage sequences?
client know skid info?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
table actions available in oracle connector?
What are the job parameters?
What are the benefits of datastage?
How do you remove duplicate values in datastage?
To see hidden files in LINIX?
