Where is the cache stored in informatica?
- 5 Answers
- 37097 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 |
what is diff between grep and find
If we have lookup table in workflow how do you trouble shhot to increase performance?
What are the main features of Oracle 8i with context to datawarehouse?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What is exclusive and normal mode for repository services?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
What is meant by incremental aggregation?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
Explain about cumulative Sum or moving sum?
What is different between the data warehouse and data mart?
What is data movement mode in Informatica and difference between them?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
Teradata 
