For stage table data processing, suppose in first run we
processed 8 records out of 10 records then in 2nd run we
should consider only not processed records (here total no
of records =2) along with new records which got loaded in
stage table thru real time mapping.
Note : In this example, 8 records are those records for
which we got transaction number after lookup on trn_no_cod
table and 2 records for which lookup returns trn_no as NULL
Answer / abhinav
In the 2nd run if u want only the records which have not
processed then do Lookup on the target and pass the output
to the target.
Is This Answer Correct ? | 0 Yes | 0 No |
How do you load only null records into target?
what is difference between dimention table and fact table?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
what is workflow varible
Explain what are the different types of transformation available in informatica.
If there are more than one sessions running parallel in a worklet, which will be the last session ?
explain about unit testing? in real time?
tell me the push down optimization
Router T/R is active but some people are saying it is also passive which is exactly right?
How to generate sequence numbers without using the sequence generator transformation?
What is update override?
Is there any model difference between ODS and DWH