Interested to Buy Any Domain ? << Click Here >> for more details...
Create a mapping which contains 2 target tables. When the
session runs for the first time it shud load Target table 1
and when it runs for second time it shud load Target
table 2.
- 7 Answers
- 14983 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / perumal
Source -> sq -> sequence Generator -> exp trans -> router
trans -> tgt1/tgt2
create variable nxt_val with next value return from seq gen
and in router give rule as mod(nxt_val,2)<>0 to load tgt1
(since first run value will be 1) and mod(nxt_val,2)=0 to
load tgt2.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Differences between version 7.x and 8.x.
Which are the different editions of informatica powercenter that are available?
How do you promote a non-reusable transformation to reusable transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are mapplets?
How is union transformation utilized?
Target increases every day even though no new record was inserted
What will be the approach?
what is the size of your data warehousing?
Explain what are the different types of transformation available in informatica.
According to his methodology what all you need before you build a datawarehouse
What are the restrictions of union transformation?
what is song in infrmatica...?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Separate from a database, an information bazaar, and an information stockroom?
