Interested to Buy Any Domain ? << Click Here >> for more details...
Where is the cache stored in informatica?
- 5 Answers
- 38398 Views
- Infosys, Satyam, I also Faced
- E-Mail Answers
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 |
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
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
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
What is CDC? How to implement CDC?
What are the different lookup cache(s)?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the Hierarchy of DWH?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
Teradata 
