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
- 7238 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
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the different types of transformation available in informatica.
What is a connected transformation?
What is the function of aggregator transformation?
What is the need of etl tools?
Design a mapping to load a target table with the following values from the above source?
what are the deliverables?in your project?
Make a note of the quantity vaults made in informatica?
What is meant by query override?
what is $$$$?
is it possible to index the data in cache of lkp transformation ?
What is the Rank index port in Rank transformation?
What differs when we choose the sorted input for aggregator transformation?
What is a predefined event?
What all join we can perform in LOOKUP transformation?
