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
- 3858 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the reusable transformation?
What is substr in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
waht is dataware house
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
How to Create a folder using pmrep command?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Why sorter is an active transformation?
Enterprise data warehouse your projects phase by phase explain?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
Teradata 
