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
- 7075 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
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How do you handle two sessions in Informatica
I have a flat file, want to reverse the contents of the flat file
How do you promote a non-reusable transformation to reusable transformation?
What is Cognos script editor?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is meant by target load plan?
What is the need of etl tools?
What will be the approach?
What are the features of complex mapping?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
COM components can be used in Informatica
what is $$$$?
