what is meant by lookup caches?
Answer Posted / swetha
The informatica server builds a cache in memory when it
processes the first row af a data in a cached look up
transformation. It allocates memory for the cache based on
the amount you configure in the transformation or session
properties. The informatica server stores condition values
in the index cache and output values in the data cache.
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Have you worked with/created Parameter file
difference between repository database and repository service?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is standalone command task?
4 yrs etl devloper roles and responsibilities?any body give solutions
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
what is degenerated dimension?
What are the different versions of informatica?
What are the tuning techniques you applied during your last project
Is stop and abort are same in informatica?
Briefly define a session task?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what is SDLC way of code development?
What is incremental aggregation?