How to generate a single mapping for both the historical
and incremental load.
- 2 Answers
- 7193 Views
- CSC, TATA, I also Faced
- E-Mail Answers
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
scenario where i can use only concurrent execution of workflow.
can we override a native sql query within informatica? Where do we do it?
What is InformaticaPowerCenter?
how many types of dimensions are available in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the uses of etl tools?
What are mapplets? How is it different from a Reusable Transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the features of complex mapping?
What is event and what are the tasks related to it?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can we use batches?
Explain sessions. Explain how batches are used to combine executions?
Briefly define reusable transformation?
