when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
Answer Posted / swapna
static cache is used when the records in the source does not update more frequently.
dynamic cache is used when the records in the source frequently updates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you generate reports in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to do unit testing in informatica? How to load data in informatica ?
Different sorts of metadata that stores in the storage facility?
What is the sequence generator transformation in informatica?
Briefly define a session task?
What are the different versions of informatica?
which one is better performance wise joiner or look up
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
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.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to open an older version of an object in the workspace?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the difference between stop and abort in informatica