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
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain direct and indirect flat file loading (source file type) - informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Clarify the utilization of aggregator cache record?
What is Data Caches size?
What is confirmed fact in dataware housing?
Is there any way to read the ms excel datas directly into informatica?
What is data caches/ index caches?
What is xml source qualifier transformation in informatica?
What is dimensional table? Explain the different dimensions.
How do we call shell scripts from informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How you prepared reports for OLAP?
What is a joiner transformation?
How many number of sessions can one group in batches?