Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 13481 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
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
How do you load unique records into one target table and duplicate records into a different target table?
how tokens will generate?
How would you join a node to the already existing domain?
What is a repository? And how to add it in an informatica client?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
permutations of mapplet
How to do unit testing in informatica? How to load data in informatica ?
What is the use of an aggregator cache file?
Can anyone tell me the new features in Informatica 9 Version?
Why do you use Mapping Parameter and mapping variable?
Differentiate between reusable transformation and mapplet.
What is exclusive and normal mode for repository services?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is the format of informatica objects in a repository?
What is transformation?
