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 |
Can you start a session inside a batch individually?
What is confirmed fact in dataware housing?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
Differentiate between a repository server and a powerhouse?
Sequence generator, when you move from develoment to production how will you reset
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
Explain the different dimensions.
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
What is a test load?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?