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
- 20982 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / anil
Hi,
This can be do easily with loops in transformer stage
Design
--------
Sq File - > Aggregrate - > Transformer - > Unique
|
Duplicate
1. In aggregate, calculate no of rows say counts
2. In transformer , define a stage variable stgTest whose derivation is if counts > 1 then 'Duplicate' Else 'Single'
3. In the loop condition define @iteration < Counts
4. Take a loop variable saying lopNumbers = EID
5. Now for Unique link write constraint as stgTest = 'Single' and output derivation of EID = @iteration.
6. Now for Duplicate link write constraint as stgTest = 'Duplicate' and output derivation of EID = @iteration.
7. Now you will get duplicate values in one link and unique values in another link.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
describe the Steps to confiure a Qlogic switch
What are the important features of datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What all the types of jobs you developed?
How to perform incremental load in datastage?
Define repository tables in datastage?
How many types of sorting methods are available in datastage?
explain about citrix scheduling tool in datastage
Explain the situation where you have applied SCD in your project?
Explain connectivity between datastage with datasources?
Have you used Unstructured data?
How you can fix the truncated data error in datastage?
What are some prerequisites for datastage?
How to reverse the string using SQL?
What is the difference between hashfile and sequential file?
