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
- 13285 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
What all are steps in up gradation of Informatica server?
Define update strategy?
How can you increase the performance in joiner transformation?
What is event and what are the tasks related to it?
What is workflow? What are the components of workflow manager?
Can we create two repositories on same database instance in oracle?
In informatica workflow manager, how many repositories can be created?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to call shell scripts from informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Reusable transformation and shortcut differences
Is stop and abort are same in informatica?
Performance tuning( what you did in performance tuning)
waht type of interface is used for testing the data in informatica
