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
- 3848 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 |
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What is staging area?
what is the diff b/w cached and unchaed look ups
How to eliminate duplicates from flat file..what is the procedure
Why update strategy and union transformations are active? Explain with examples.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
What are the data movement modes in informatica?
difference between shortcut and reusable transformation?
What are the reusable transformations?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
Teradata 
