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
- 5536 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
As union transformation gives UNION ALL output, how you will get the UNION output?
can u give example for factless fact table
How would you copy the content of one repository to another repository?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the main issues while working with flat files as source and as targets ?
pmscmd startworkflow -sv
What is a mapplet/worklet in informatica?
What is a filter transformation and why it is an active one?
What is a transaction control transformation?
What is session task and command task?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
lookup transformation with screenshots
How to join three sources using joiner? Explain though mapping flow.
