I have one source table and three target tables.
When the session runs for the first time involving the
mapping,i want that the loading should take place in 1st
Target table only.
The 2nd time the same session runs the loading should take
place in 2nd Target only only
and similarly when the session runs for the 3rd time loading
should take place in Third only.
And again when the session runs for the 4th time loading
should take place in 1st Target table.
Answer Posted / bhupal
Hi all,
Use sequence generator to generate the sequence.
properties should be
start value=1
end value=3
check the cycle option.
connect this nextvalue port to router and make there groups.
group_1----> nextvalue=1
group_2----> nextvalue=2
group_3----> nextvalue=3
connect first group to first target and second group to second target and then third to third.
flow will be like this
sequence generator
|
source---->source qualifier---->router--------Target 1
|-----------Target 2
|-----------Target 3
please let me know if you have any new questions.
mail id: bhupalreddy200@gmail.com
Is This Answer Correct ? | 1 Yes | 20 No |
Post New Answer View All Answers
What do you mean by channel change?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is powercenter on grid?
What is main use of mapplet?
How do you load first and last records into target table?
What are the new features of informatica 9.x at the developer level?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How do you promote a non-reusable transformation to reusable transformation?
What is the format of informatica objects in a repository?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is meant by incremental aggregation?
How would you copy the content of one repository to another repository?
How to update a particular record in target with out running whole workflow?
What is the Process to creating lookup transformation in informatica