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
- 6870 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
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is informatica? Why do we need it?
What is InformaticaPowerCenter?
Difference between Data and Index Caches?
What is the benefit of session partitioning?
have u done any performance tuning? how u ll do?
What is a dimensional model?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Whats the difference between informatica powercenter server, repositoryserver and repository?
Define joiner transformation?
Explain in detail scd type 2 through mapping.
Separate from a database, an information bazaar, and an information stockroom?
How do we call shell scripts from informatica?
what is mean by complex business rule ?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
