what is the diff b/w cached and unchaed look ups
Answer Posted / sujana
if v cache the lukup..IS queries the cache for each row dat
eneters
if v dont cache IS queries the database for each row dat
enters..i.e issues a slect statemnt for each row
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
what is the -ve test case in your project.
How many ways a relational source definition can be updated and what are they?
Can anyone tell me the new features in Informatica 9 Version?
What are the different clients of powercenter?
Enlist the tasks for which source qualifier transformation is used.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the surrogate key?
What is the use of transformation?
Explain pmcmd command usage in informatica
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Informatica settings are available in which file?
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 if the source is a flat-file?
What are the new features of Power Center 5.0?