Answer Posted / veni
Persistent cache: U can save the lookup cache files and
reuse them the next time the informatica server processes a
lookup transformation configured to use the cache.
Recache from database: If the persistent cache is not
synchronized with he lookup table,U can configure the lookup
transformation to rebuild the lookup cache.
Static cache: U can configure a static or readonly cache for
only lookup table.By default informatica server creates a
static cache.It caches the lookup table and lookup values in
the cache for each row that comes into the
transformation.when the lookup condition is true,the
informatica server does not update the cache while it
prosesses the lookup transformation.
Dynamic cache: If u want to cache the target table and
insert new rows into cache and the target,u can create a
look up transformation to use dynamic cache.The informatica
server dynamically inerts data to the target table.
shared cache: U can share the lookup cache between multiple
transactions.U can share unnamed cache between
transformations inthe same maping.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to configure mapping in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
How you can differentiate between connected lookup and unconnected lookup?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Separate from a database, an information bazaar, and an information stockroom?
Mention a few design and development best practices for informatica?
What is a rank transform?
Explain the etl program with few examples.
Explain the types of lookup transformation?
How can we use mapping variables in informatica? Where do we use them?
What is the need of etl tools?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the sequence generator transformation in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
