How to generate a single mapping for both the historical
and incremental load.
- 2 Answers
- 7433 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
What is a standalone command task?
explain abt ur project architecture?
How would you join a node to the already existing domain?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Differentiate between a repository server and a powerhouse?
What happens when a session fails and you click on recover?
what is mean by complex business rule ?
What are the mapping parameters and mapping variables?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
how to create user defined function (udf) in informatica
In development project what is the process to follow for an etl developer from day1
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Describe expression transformation?
Explain direct and indirect flat file loading (source file type) - informatica
Please let me know how to make encryption and decryption with example?
