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
What is a code page?
What is workflow? What are the components of workflow manager?
What is primary and backup node?
What do you mean incremental aggregation?
What is informatica powercenter repository?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
what is mean by complex business rule ?
What are ETL Tools?
How can you define user defied event?
What is the use of transformation?
Explain the use of aggregator cache file?
How can we create index after completion of load process?
On which transformations you created partitions in your project?
What is confirmed fact in dataware housing?
What are the various types of transformation?