how u know when to use a static cache and dynamic cache in
lookup transformation.

Answer Posted / hari

By default lookup is static.
Dynamic is used whn the records coming frm the source to
target in multiple times. i.e if
1)
emp_id=101...city=hyd...age=25...
(first this is inserted to target)
2)at second time when 101 employee is changing his city frm
hyd to chennai here we need to update the target table with
city name as chennai. thn how lookup cache knows tht a
record is updated...
3) if it is static lookup, after updating tht record it
will not refresh the lookup cache.... where as if it is
dynamic cache it will refresh the cache....
4) Based on our requirement we r going to use.....

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the guidelines to be followed while using union transformation?

910


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.

1825


scenario where i can use only concurrent execution of workflow.

2825


What is aggregator transformation in informatica?

760


What is depict expression change?

831


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

823


Reusable transformation and shortcut differences

1619


Name the different lookup cache(s)?

953


What is joiner change?

940


What are the basic requirements to join two sources in a source qualifier transformation using default join?

847


Can we create a Integration service without a Repository service and vice versa?

1018


Which development components of informatica have the highest usage?

834


have u done any performance tuning? how u ll do?

2097


where to store informatica rejected data? How to extract the informatica rejected data?

815


Can anyone tell me the new features in Informatica 9 Version?

1814