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 |
How to load query faster,so that It will take less time to load?
how remove 1st 3 records & last 3 records in informatics
What do you mean by worklet?
What is the Rank index port in Rank transformation?
wf dont have integration severances how you can run?
can you use flat file for lookup table?why?
In informatica workflow manager, how many repositories can be created?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
what is target update override and when we use it?