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.

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.

Answer / ashok

Cache is stored in a cache directory.(You can specify
whereever you want in your unix box(repository)).

Answer / ramana

Informatica server allocate the cache

Answer / rajesh chowdary

caches are default stored no need to particular location

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

What is the Hierarchy of DWH?

1 Answers  

Diff b/w ShortCut and reusabel Object ?

4 Answers  

What are session parameters ? How do you set them?

0 Answers  

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

What are active and passive transformations?

0 Answers   Informatica,

what is the -ve test case in your project.

0 Answers   CTS, TCS,