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
- 8088 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 the difference between the local container and shared container?
What is the difference between validated and compiled in the datastage?
What is orabulk stage?
What are the types of containers in datastage?
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between datastage and informatica?
How many types of sorting methods are available in datastage?
What are the functionalities of link partitioner?
Differentiate between datastage and informatica?
Difference between server jobs & parallel jobs?
What are the job parameters?
How rejected rows are managed in datastage?
Nls stands for what in datastage?
How we can covert server job to a parallel job?
What is the difference between datastage and datastage tx?
