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
- 10408 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 will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How can we improve session performance in aggregator transformation?
What is Cognos script editor?
How can we use batches?
What are data-driven sessions?
what is Active lock explain
What is the advantage of informatica?
What is a predefined event?
What is mapping debugger?
Describe expression transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How do you load only null records into target? Explain through mapping flow.
Why do you use Mapping Parameter and mapping variable?
