how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / abhsihek
Hi neetu,
as i know that dynamic lookup alway increase the perfomence
compratively static cache if i am wrong please let me know.
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
What are the transformations that are not supported in mapplet?
What is a filter transformation and why it is an active one?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is joiner transformation?
How many dimensions are there in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How might you approve all mappings in the archive all the while?
What are the different types of olap? Give an example?
What are the different lookup cache(s)?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
lookup transformation with screenshots
How to load the data from people soft hrm to people soft erm using informatica?
Can we get 1st record through Informatica(without sequence number).
Write the unconnected lookup syntax and how to return more than one column.