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
- 3746 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the maplet?
What is the meaning of decode in informatica?
What is a filter transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Write the unconnected lookup syntax?
What is the use of source qualifier?
Implementation methodology
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
In warehouses how many schemas are there?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to create or import flat file definition in to the warehouse designer?
what is Active lock explain
What is domain in terms of informatica?
What is an aggregator transformation?
What are the informatica performance improvement tips
