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
- 8086 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 is the command line function to import and export the ds jobs?
Does datastage support slowly changing dimensions ?
What is the difference between odbc and drs stage?
What are routines in datastage?
AGGREGATOR default datatype
How many types of sorting methods are available in datastage?
Why fact table is in normal form?
How to manage date conversion in Datastage?
What is a merge?
What are some different alternative commands associated with "dsjob"?
Define Merge?
what is the use of skid in reporting?
What are stage variables?
What is the difference between orabulk and bcp stages?
What are the types of containers and how to create them?
