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
- 7104 Views
- HCL, I also Faced
- E-Mail Answers
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
What is a passive transformation?
Explain constraint based loading in informatica
What is union transformation?
How to join three sources using joiner?
What is the difference between informatica 7.0 and 8.0?
Explain how to import oracle sequence into informatica?
What are the components of workflow manager?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
without table how to come first record only in oracle?
How to improve the performance of a session using sorter transformation?
How do you load first and last records into target table?
How does a sorter cache works?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the different versions of informatica?
What is joiner transformation in informatica?
