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?
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
Define mapping and session?
can anyone explain me about retail domain project in informatica?
Explain target update override in informatica
Explain sessions. Explain how batches are used to combine executions?
What is a joiner transformation?
Tell me about Propagate functions in informatica
server hot-ws270 is connect to Repository B. What does it mean?
What is aggregator transformation in informatica?
Make a note of the quantity vaults made in informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are different types of transformations available in informatica?
What you know about transaction control transformation?
Define the various join types of joiner transformation?
waht type of interface is used for testing the data in informatica
What is the sequence generator transformation in informatica?