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
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 the difference between validated and compiled in the datastage?
What are the partitioning techniques available in link partitioner?
what is repositery?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the purpose of pivot stage?
How rejected rows are managed in datastage?
What are stage variables?
How can one find bugs in job sequence?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Define ds designer?
What are the primary usages of datastage tool?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is "fatal error/rdbms code 3996" error?
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?