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 / 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
what is ds administrator used for?
What is the difference between datastage and informatica?
Describe link sort?
What is the command line function to import and export the ds jobs?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Describe the main features of datastage?
What are the areas of application?
What are routines in datastage? Enlist various types of routines.
Define Job control?
What are the components of datastage?
How will you move hashed file from one location to another location?
What is the difference between in process and inter process?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?