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
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How to generate sequence numbers without using the sequence generator transformation?
can we override a native sql query within informatica? How do we do it?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain the code page compatibility?
In development project what is the process to follow for an etl developer from day1
Explain how many types of dimensions are available in informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is repository manager?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain pushdown optimization $pushdownconfig parameter - informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How many transformations can be used in mapplets.
To import the flat file definition into the designer where should the flat file be placed?
What is the function of union transformation?