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
- 3674 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 junk dimention?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
In a concurrent batch if a session fails, can you start again from that session
What is deployemnt groups, Lables, query and dynamic deployment group.
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
what is worklet and what use of worklet and in which situation we can use it?
How to create a non-reusable instance of reusable transformations?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
Can anyone tell me the new features in Informatica 9 Version?
what is materialized view?
Router T/R is active but some people are saying it is also passive which is exactly right?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Teradata 
