Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
Target increases every day even though no new record was inserted
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Explain load alternative records / rows into multiple targets - informatica
How might one distinguish in the case of mapping is right or not without associating session?
what are the deliverables?in your project?
Different sorts of metadata that stores in the storage facility?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
is it possible to index the data in cache of lkp transformation ?
How many numbers of sessions can one group in batches?
What could be the possible resons of locks by user?
COM components can be used in Informatica
what is the size of your data warehousing?
Explain the types of transformations?
What is a standalone command task?
