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 the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
How can you display only hidden files in UNIX
Write the advantages of partitioning a session?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
How you count the number of records available at your source?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Plz can any one say me how to get the informatica certification materials and dumps
What are the challenges of Dataware housing in the future?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
what is correlated query?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?