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
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is union transformation?
What do mean by local and global repository?
Describe data concatenation?
Describe expression transformation?
Differences between connected and unconnected lookup?
Where can we find the throughput option in informatica?
Define mapping and session?
State the differences between sql override and lookup override?
What is the meaning of decode in informatica?
What is informatica? Why do we need it?
What are the differences between source qualifier and joiner transformation?
what is informatica metadata?
What is meant by lookup transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?