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
- 8214 Views
- TCS, I also Faced
- E-Mail Answers
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 repository tables in datastage?
Difference between sequential file and data set?
How to implement complex jobs in data stage?
What are the steps required to kill the job in Datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the types of containers and how to create them?
What are the types of views in datastage director?
Can you filter data in hashed file?
Which commands are used to import and export the datastage jobs?
CHANGE CAPTURE
Nls stands for what in datastage?
What is aggtorec restructure operator?
What is oci?
How complex jobs are implemented in datstage to improve performance?
EXPLAIN SCD
