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 do you create single lookup transformation using multiple tables?
Difference Between ETL & ELT?
how can we run workflow with pmcmd?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Why the workflow is failed after running two hours in informatica?
what is metadata?
what is incremental aggregation ,with example?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
How mapping parameter and variable works
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain the types of transformations?