how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / amit
when we use conneted type of lookup then we use dynamic
caches& when we use unconncted lookup in the modelling we
use static cache
Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
What is workflow? What are the components of the workflow manager?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is transformation?
What is source qualifier transformation in informatica?
Define filter transformation?
Explain dynamic target flat file name generation in informatica
According to his methodology what all you need before you build a datawarehouse
How can we create index after completion of load process?
What are the components of the workflow manager?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Write the different tools in the workflow manager?
Explain in detail scd type 2 through mapping.
What is resilience time?
What is complex mapping?