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.
Answer Posted / subhajit
Alternative to mapping variable:
Use sequence generator, mod on that and then finally router.
Thanks
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between informatics 7x and 8x and what is latest version?
How to partition the Session?
What are the types of caches in lookup?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
To import the flat file definition into the designer where should the flat file be placed?
Differentiate between joiner and lookup transformation?
Explain target update override in informatica
Explain what is informatica metadata and where is it stored?
Can you use flat files in Mapplets.
What is the command used to run a batch?
What is a dimensional model?
What are the new features of informatica 9.x at the developer level?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How might one distinguish in the case of mapping is right or not without associating session?
What are the performance considerations when working with aggregator transformation?