what is the diff b/w cached and unchaed look ups
Answer Posted / sunil
when lookup cahing is unabled, informatica server queries
the lookup table once,caches the lookup values during
session.This can inprove session performance.
when u disable lookup caching,each time row pass to the
transformation,informatica server issues an select
statement to lookup table for lookup values
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the components of workflow manager?
What is enterprise data warehousing?
How you can differentiate between connected lookup and unconnected lookup?
what are the Methods For Creating Reusable Transformations?
How can you validate all mappings in the repository simultaneously?
How do you change a non-reusable transformation to reusable transformation?
How would you join a node to the already existing domain?
what is diff b/t sorter t/r and agg have the option sorter property...
What does cheating measurement mean?
Why update strategy and union transformations are active? Explain with examples.
What are connected or unconnected transformations?
What is session task and command task?
What are batches?
how to load rows into fact table in data warehouse
What are the types of caches in lookup?