what is meant by lookup caches?
Answers were Sorted based on User's Feedback
Answer / swetha
The informatica server builds a cache in memory when it
processes the first row af a data in a cached look up
transformation. It allocates memory for the cache based on
the amount you configure in the transformation or session
properties. The informatica server stores condition values
in the index cache and output values in the data cache.
Is This Answer Correct ? | 15 Yes | 2 No |
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
which transformation uses cache?
How can you differentiate between powercenter and power map?
how many types of dimensions are available in informatica?
Write the unconnected lookup syntax and how to return more than one column.
Differentiate between source qualifier and filter transformation?
what is the architecture of any Data warehousing project?
Can we create out put ports in source qualifier t/r?
How we will implement Pushdown Optimization and Types in Informatica with better examples
in realtime which situations u can use unconnected lookup transformation
how to remove staging area
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION