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 informatica?
What is intricate mapping?
Enlist the differences between database and data warehouse.
How do you set a varible in incremental aggregation
Explain the pipeline partition with real time example?
how to load rows into fact table in data warehouse
How to generate sequence numbers without using the sequence generator transformation?
Did u used latest transformations of 8.6.0? for what?
What is transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Name the different lookup cache(s)?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is mapping debugger?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you change a non-reusable transformation to reusable transformation?