Where is the cache stored in informatica?
Answers were Sorted based on User's Feedback
Answer / dr.jornalist
For lookup, by default the cache is stored in $PMCACHEDIR
in the informatica server directory
You can aslo give ur own settings where you need to store
the cache values.
| Is This Answer Correct ? | 22 Yes | 4 No |
Answer / sgk
Cache is stored in the cache directory.
For Aggregator,Joiner and Lookup transformations cache
values is stored in the cache directory.
For sorter transformation cache values stored in the temp
directory.
| Is This Answer Correct ? | 11 Yes | 5 No |
Answer / ashok
Cache is stored in a cache directory.(You can specify
whereever you want in your unix box(repository)).
| Is This Answer Correct ? | 9 Yes | 6 No |
Answer / rajesh chowdary
caches are default stored no need to particular location
| Is This Answer Correct ? | 1 Yes | 14 No |
can a port in expression transf be given the name DISTINCT
What is power play plug in?
Whats there in global repository
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
How union transformation is used?
How to import oracle sequence into Informatica?
difference between informatica 8.1.1 and 8.6
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
how can we use sorter transformation in joins?
What is the different lookup cache(s)?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!