Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 3723 Views
- I also Faced
- E-Mail Answers
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 index?how it can work in informatica
can we override a native sql query within informatica? Where do we do it?
What is the use of target designer?
How to do the error handling of if ur source is flatfiles?
What is target load order?
What is the scenario which compels informatica server to reject files?
Define update strategy?
What are the differences between oltp and olap?
what are the deliverables?in your project?
What are the different types of repositories created using informatica?
How can we create index after completion of load process?
What is sequence generator transformation in informatica?
Differentiate between router and filter transformation?
what is degenerated dimension?
What are the different clients of powercenter?
