Where is the cache stored in informatica?
Answer Posted / 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 |
Post New Answer View All Answers
Explain sessions. Explain how batches are used to combine executions?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the differences between joiner transformation and source qualifier transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a surrogate key?
How can informatica be used for an organization?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the main issues while working with flat files as source and as targets ?
Different sorts of metadata that stores in the storage facility?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How big was your fact table
What is different between the data warehouse and data mart?
How to create Target definition for flat files?
What is enterprise data warehousing?