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

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

---

What do you understand by a term domain?

0 Answers  

---

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

---

What are the active and passive transforamtions?

2 Answers  

---

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

---

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---