what is the significance of newlookup port in dynamic look up
Answer Posted / suraj kedia
When we configure a look up t/r to use a dynamic cache, the
designer automatically adds a port called "New Lookup Row"
to the look up t/r. This port indicates with a numeric value
whether the Informatica server inserts or updates the row in
the cache or makes no change in the cache.
To keep the lookup cache and the target table
synchronised, we pass rows to the target when the New Lookup
Row value is equal to 1 or 2.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
What is the surrogate key?
What are multi-group transformations?
Did u used latest transformations of 8.6.0? for what?
How union transformation is used?
Explain lookup transformation in informatica
Where are the source flat files kept before running the session?
Explain the etl program with few examples.
What is a dimensional model?
What is dimensional table?
Partition, what happens if the specified key range is shorter and longer
what is song in infrmatica...?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How many dimensions are there in informatica?