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
- 14974 Views
- TCS, I also Faced
- E-Mail Answers
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 target load order?
Differentiate between joiner and lookup transformation?
Explain about Informatica server process that how it works relates to mapping variables?
scenario where i can use only concurrent execution of workflow.
Can we override a native sql query within informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
While migrating the data from one environment to another environment how would you manage the connections?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is an expression transformation?
What do you mean incremental aggregation?
How to create or import flat file definition in to the warehouse designer?
How might you approve all mappings in the archive all the while?
generate date / time dimension in informatica
If informatica has its scheduler why using third party scheduler?
Write the advantages of partitioning a session?
