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 ? | 21 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 |
Label in Informatica. How to remove existing Label.
what transformations are used for Variable port?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
In update strategy target table or flat file which gives more performance ? why?
What are the main issues while working with flat files as source and as targets ?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
How to get EVEN & ODD numbers separately?
How to delete duplicate record in Informatica?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?