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 are the new features of informatica 9.x developer?
What is option by which we can run all the sessions in a batch simultaneously?
Did u used latest transformations of 8.6.0? for what?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Write the unconnected lookup syntax and how to return more than one column.
Which is the t/r that builts only single cache memory?
What is meant by incremental aggregation?
What is enterprise data warehousing?
What is mapplet in informatica?
How can repository reports be accessed without sql or other transformations?
permutations of mapplet
What are the designer tools for creating transformations?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How do you load alternate records into different tables through mapping flow?
Repository user profiles