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
Answer Posted / sg
SQ-Exp-Rou-Tg1 TG2 Tg3
Exp transformation: for generating sequence number ( u can use sequence generator setting max value to 3)
o_count = iff(o_count=0 or o_count=4,1,o_count+1)
Router group condition,
O_cout=1, TG1
O_cout=2, TG2
O_cout=3, TG3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain pmcmd command usage in informatica
Explain Dataware house architecture .how data flow from intial to end?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
how many types of dimensions are available in informatica?
What are the mapping parameters and mapping variables?
What is a code page?
How to implement security measures using repository manager?
Is stop and abort are same in informatica?
What are data-driven sessions?
Mention few advantages of router transformation over filter transformation.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What you know about transaction control transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is repository manager?
How we can create indexes after completing the load process?