Where is the cache stored in informatica?
- 5 Answers
- 35758 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 ? | 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 |
we have to use order by,where,having we to implement sql query
Why you use repository connectivity?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
How do you implement unconn. Stored proc. In a mapping?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is factless fact schema?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
Explain the difference between a data warehouse and a data mart?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what is mean by complex business rule ?
What is the use of an aggregator cache file?
Teradata 
