Answer Posted / santoshkumar chakka

I know abt 4 types lookup's
they are
1.static lookup
2.dynamic lookup
3.persistence lookup
5.No Cache lookup
PERSISTENCE LOOKUP:By default .dat and .idx files are created using session execution time and these are deleted automatically at the end of session execution using persistence property the cache files are not deleted even after session execution.the same cache files are uesed for next exicution

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5794

---

Reusable transformation and shortcut differences

1840

---

How we can create indexes after completing the load process?

1160

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

---

How to update a particular record in target with out running whole workflow?

1576

---

How can you differentiate between powercenter and power map?

1091

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1063

---

What is the difference between source qualifier transformations source filter to filter transformation?

1056

---

What is fact table? Explain the different kinds of facts.

1077

---

Why sorter is an active transformation?

1195

---

How to extract sap data using informatica?

1043

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1782

---

Difference between Data and Index Caches?

1138

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2747

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1323

---