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 does command task mean?
How to load a Dimension ? and how to load a fact table?
What is an expression transformation?
What is a passive transformation?
What is a snowflake schema?
What is an unconnected transformation?
can u any challenge your project?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
whats the logic to load the lower level of granularity of data to fact table.
How to call shell scripts from informatica?
Describe expression transformation?
Define enterprise data warehousing?
How can informatica be used for an organization?