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
- 8263 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 difference between symmetric multiprocessing and massive parallel processing?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Can you highlight the main features of ibm infosphere information server?
Describe link sort?
What is apt_config in datastage?
What are the benefits of datastage?
Why we use surrogate key?
What is the use of datastage director?
Which algorithm you used for your hashfile?
How to clean the datastage repository?
What is staging variable?
What all the types of jobs you developed?
What are stage variables and constants?
How do you schedule or monitoring the job?
How do you import and export data into datastage?
