Interested to Buy Any Domain ? << Click Here >> for more details...
What is A cache?
- 2 Answers
- 7333 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 the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
How to generate sequence numbers?
How do you implement configuration management in Informatica?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Why is meant by direct and indirect loading options in sessions?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
Why do you use Mapping Parameter and mapping variable?
What are the types of groups in Router transformation?
Teradata 
