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
- 8220 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 oci?
what are the devoleper roles in real time? plz tell i am new to datastage....
Different ways a project can be moved to production ?...example ….export-import and Version control.
Have you have ever worked in unix environment and why it is useful in datastage?
Demonstrate experience in maintaining quality process standards?
What is the precedence of stage variables,derivations, and constraints?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Can you highlight the main features of ibm infosphere information server?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How do you register plug-ins?
Describe link sort?
What is the use of hoursfromtime() function in transformer stage in datastage?
How do you import and export data into datastage?
What is aggtorec restructure operator?
Why do we use link partitioner and link collector in datastage?
