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 a design?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the new features of informatica 7.1?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
How Union Transformation is an Active Trans?
what are the types of facts with Examples?
what transformations are used for Variable port?
Can we get 1st record through Informatica(without sequence number).
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
"Change cache" in Informatica ?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you