Interested to Buy Any Domain ? << Click Here >> for more details...
What is A cache?
- 2 Answers
- 7436 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srikanth
A cache is a memory area where informatica server holds the
data to perform calculations during the session. It
creates cache files in the $PMcachedir and as soon as the
session finishes, server deletes the cache files from the
directory.
if we know the data does not change between session runs,
we can persist on the disk (persistent cache ) and use
those files in other sessions. in this case, the server
does not delete the cache files as soon as the session
finishes.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is transformation?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
Explain one complecated mapping?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
Explain the difference between a data warehouse and a data mart?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
what is the main advantage of unconnected lookup
what are the types of Data warehousing ?
All active transformations r passive or not?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
Teradata 
