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
- 13473 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
Write the program through which the records can be updated?
What is deployment group?
Whats there in global repository
Explain the scenario which compels informatica server to reject files?
What are the differences between oltp and olap?
Mention few power centre client applications with their basic purpose?
How do you manage the Parameter files while migrating your data from one environment to another environment?
have u done any performance tuning? how u ll do?
Is there any way to read the ms excel datas directly into informatica?
How are indexes created after completing the load process?
How to update source definition?
Can we create multiple integration service on single repository?
What are the new features of informatica 9.x developer?
Explain the use of aggregator cache file?
Explain how many types of dimensions are available in informatica?
