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 do you understand by a term domain?
What is a connected transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Which are the different editions of informatica powercenter that are available?
What is a mapplet/worklet in informatica?
What you know about transaction control transformation?
Have you worked with/created Parameter file
What is sequence generator transformation in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How might you approve all mappings in the archive all the while?
What is status code in informatica?
How you can differentiate between connected lookup and unconnected lookup?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to join three sources using joiner? Explain though mapping flow.
What is the difference between source qualifier transformations source filter to filter transformation?