Answer Posted / mike
The informatica server builds a cache in the memory when it
process the first row of a cached lookup transformation.It
allocates the memory based on the amount you configure in
the trandformation or session properties.The informatica
server stores the conditional values in the index cache and
data values in the data cache..
correct me if i was wrong
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is the difference between informatica6.1 and infomatica7.1
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Design a mapping to load a target table with the following values from the above source?
What are the different types of olap? Give an example?
Tell me about MD5 functions in informatica
What all are steps in up gradation of Informatica server?
What are the popular informatica products?
How union transformation is used?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
what are the deliverables?in your project?
How do you load alternate records into different tables through mapping flow?