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
- 3722 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 rank index in rank transformation?
How can a transformation be made reusable?
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
How we will implement Pushdown Optimization and Types in Informatica with better examples
why union is active transformation?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Design a mapping to load the cumulative sum of salaries of employees into target table?
Is it possible to have "5 source & 5 Target" in single mapping?
What is the use of code page?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
What are teh different tasks that can be created in workflow manager?
Teradata 
