How to generate a single mapping for both the historical
and incremental load.
Answers were Sorted based on User's Feedback
Answer / rahul
hi Allen,
i didnt get it.
can you tel what is EOM. y you used month key from monthly
session.
i Question he didnt tell that we are loading on monthly bases.
pls explain it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is souce qualifier transformation it is active or passive
How does the session recovery work.
What is an expression transformation in informatica?
in which situations do u go for snowflake schema ?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
How to load duplicate records in to a target table which has a primary key?
one source to target loading insert new rows and update existing rows?
What are the associated ports in look up T/R.
what is the predefined port in dynamic lookup
what are the types of facts with Examples?