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
State the limitations where we cannot use joiner in the mapping pipeline?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain direct and indirect flat file loading (source file type) - informatica
In which transformation you cannot drag ports into it?
What are the types of caches in lookup? Explain them.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to Create a folder using pmrep command?
What are Dimensional table?
tell me about your project functionality
How to load the data from a flat file into the target where the source flat file name changes daily?
What is a passive transformation?
what is SDLC way of code development?
To import the flat file definition into the designer where should the flat file be placed?
What are the advantages of informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks