how can we check whether a particular cache is static or
dynamic?



how can we check whether a particular cache is static or dynamic?..

Answer / praveen n

Double click the lookup transformation, check the properties
tab, if check port of dynamic lookup cache selected or not,
if it is selected it is dynamic cache and if not it is static

Static cache: it is read only and persistent
Dynamic cache: it is changing during the session runs.
Thanks
Praveen

Is This Answer Correct ?    20 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,


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.

0 Answers  


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  


What is pmcmd command?

0 Answers  


How do you take back up of repository?

0 Answers  


What are the new features of informatica 9.x developer?

0 Answers  


i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,


How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,


"Change cache" in Informatica ?

2 Answers  


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


can a port in expression transf be given the name DISTINCT

3 Answers  


Categories