how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / 24/12/2007
if you need the source data after look up transformation to
transfer any other transformation more than once you can use
dynamic cache otherwise use static cache
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is data transformation manager process?
How we can create indexes after completing the loan process?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the features of complex mapping?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to load a Dimension ? and how to load a fact table?
What is target designer and target load order?
How many input parameters can exist in an unconnected lookup?
What is a surrogate key?
What do you understand by term role-playing dimension?
What is mapplet in informatica?
how many types of dimensions are available in informatica?
How do you load only null records into target?
Informatica settings are available in which file?