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
- 3761 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 |
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
What are the phases in SDLC?
What happens if we dont select data driven option?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
Enlist the differences between database and data warehouse.
How to recover sessions in concurrent batches?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
Scheduling properties,whats the default (sequential)
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
Where is the cache stored in informatica?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
Teradata 
