How to generate a single mapping for both the historical
and incremental load.
Answer Posted / allen
Used a router on only populate target two in the mapping on
EOM. The table was partitioned by day key and month key.
This required only one running of the mapping.
A second method was to use the a lookup override to provide
the month key from the monthly session. This required
running the mapping twice.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
What are the reusable transformations?
How would you copy the content of one repository to another repository?
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?
Define the various join types of joiner transformation?
what is the -ve test case in your project.
Does an informatica transformation support only aggregate expressions?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a pre-defined event and user-defined event?
What is Data Caches size?
What is workflow manager?
what is index?how it can work in informatica
What is olap (on-line analytical processing?
What is the function of look up transformation?
What is the difference between informatica 7.0 and 8.0?