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 / subhash
1. SRC--->FILTER---->TGT1,TGT2,TGT3
In source query,
SELECT COL1,
RANK() OVER(PARTITION BY COL1 ORDER BY COL1) SNO
FROM TABLE
in filter,
col1='d1'------>TGT1
col1='d2'------>TGT2
col1='d3'------>TGT3
2. SRC---->TFM---->TGT1,TGT2,TGT3
in TFM, do the HASH partitioning on col1 and use the stage
varibles as below:
if col1 =prevCol then SV1=S1+1
else SV1=1
prevCol---->col1
In the link constraints:
TGT1 link, COL1='d1'
map SV1, COL1 to the tgt.
TGT2 link, COL1='d2'
map SV1, COL1 to the tgt.
TGT3 link, COL1='d3'
map SV1, COL1 to the tgt.
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What are the different type of jobs in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is quality stage?
What all the types of jobs you developed?
What is the different type of jobs in datastage?
How do you import and export the datastage jobs?
What are the areas of application?
How we can covert server job to a parallel job?
What are stage variables?
How many Key we can define in remove duplicate stage?
Name the command line functions to import and export the DS jobs?
How many types of views are there in a datastage director?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
what is use of SDR function?