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 |
What is the main difference between a Joiner Transformation and Union Transformation?
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
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.
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
What is pmcmd command?
How do you take back up of repository?
What are the new features of informatica 9.x developer?
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
How many ways a relational source definition can be updated and what are they?
"Change cache" in Informatica ?
Normalizer transformation is not involved in Mapplet.. why???
can a port in expression transf be given the name DISTINCT