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 Posted / 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 |
Post New Answer View All Answers
How you know when to use a static cache and dynamic cache in lookup transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How are indexes created after completing the load process?
Explain the use of aggregator cache file?
Explain the difference between mapping parameter and mapping variable?
How to load a Dimension ? and how to load a fact table?
What are the measure objects?
what is SDLC way of code development?
What is meant by pre and post session shell command?
How would you copy the content of one repository to another repository?
What are the differences between a connected lookup and unconnected lookup?
What is the reusable transformation?
What is meant by LDAP users?
Explain what are the different versions of informatica?
lookup transformation with screenshots