Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source table and 3 target table.
when session runs first time-1st tgt
second time-2nd tgt
third time-3rd tgt
fourth time-again 1st target. so no
- 4 Answers
- 7078 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kuni_ankita
Take one variable $$var
in exp trans take one variable port and assign set variable($$var,$$var+1)
then take one router transformation with three group
mod($$var,3)=1 to one tgt
mod($$var,3)=2 to next tgt
mod($$var,3)=0 to another tgt
SD-SQ-EXP-ROUTER-TD1 TD2 TD3
| Is This Answer Correct ? | 6 Yes | 0 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?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the static cache and dynamic cache in informatica?
What differs when we choose the sorted input for aggregator transformation?
What is workflow monitor?
Performance tuning in UNIX for informatica mappings?
What is meant by query override?
What is informatica metadata and where is it stored?
Tell me about Propagate functions in informatica
What is sq transformation?
What is the sequence generator transformation in informatica?
Have you worked with/created Parameter file
Differences between connected and unconnected lookup?
What is a pre-defined event and user-defined event?
Make a note of the quantity vaults made in informatica?
