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
What are the guidelines to be followed while using union transformation?
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.
scenario where i can use only concurrent execution of workflow.
What is aggregator transformation in informatica?
What is depict expression change?
How many ways a relational source definition can be updated and what are they?
Reusable transformation and shortcut differences
Name the different lookup cache(s)?
What is joiner change?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Can we create a Integration service without a Repository service and vice versa?
Which development components of informatica have the highest usage?
have u done any performance tuning? how u ll do?
where to store informatica rejected data? How to extract the informatica rejected data?
Can anyone tell me the new features in Informatica 9 Version?