Interested to Buy Any Domain ? << Click Here >> for more details...
6) my sorce
d1
d2
d1
d2
d1
d3
d2
d1
my target
tartget
1 d1
2 d1
3 d1
4 d1
target2
1 d2
2 d2
3 d3
Target 3
1 d3
Can any body send me answer this is argent requierment
- 3 Answers
- 8394 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ankit gosain
Hi,
The solution to the problem can be achieved by the below
job structure & settings:
Source---->SortStage---->Transformer---->Tgt1,Tgt2,Tgt3
1. In Sort Stage, sort in assending mode w.r.t. source
column (say col1) & Create a change key column (say
ChangeKey).
2. In Transformer stage, create a stage variable (say
count) & it's derivation would be:
if ChangeKey=1 then 1 else count+1
3. Constraint for Tgt1 => col1=d1
Constraint for Tgt2 => col1=d2
select otherwise constraint for Tgt3.
Cheers,
Ankit :)
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is usage analysis in datastage?
What all are the different way to run a job?
How can we improve the performance in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
Enlist various types of routines in datastage.
How to reverse the string using SQL?
What steps should be taken to improve Datastage jobs?
What are the features of datastage flow designer?
How to implement complex jobs in data stage?
Why fact table is in normal form?
how to export or import the jobs in .ISX file
Could anyone give brief explanation bout datastage admin
Describe the main features of datastage?
How do you import and export data into datastage?
What is datastage?
