Interested to Buy Any Domain ? << Click Here >> for more details...
100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
- 3 Answers
- 11373 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / chandra
SQ--->EXP-->ROUTER---->TARs
In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is the need of an ETL tool?
What is dimensional table? Explain the different dimensions.
How many dimensions are there in informatica?
Why update strategy and union transformations are active? Explain with examples.
How can we use batches?
What is meant by query override?
What is meant by target load plan?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What do think which one is the better joiner or look up?
What is the Process to creating lookup transformation in informatica
How can one identify whether mapping is correct or not without connecting session?
What is main use of mapplet?
What is a rank transform?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain how to import oracle sequence into informatica?
