Answer Posted / piya

Hi Mukesh,

This is Piya can you please send informatica
certification mail id is piya.cathrine@gmail.com

Thanks in Advance
Piya

Explain about Informatica server process that how it works relates to mapping variables?

1010

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1560

---

What is a transaction control transformation?

1145

---

Make a note of the quantity vaults made in informatica?

945

---

COM components can be used in Informatica

2315

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7117

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1645

---

explain one complex mapping with logic? sales project?

6596

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2323

---

How to go to the older version for a mapping?

1031

---

Explain the tuning lookup transformation - informatica

954

---

What is sorter transformation?

979

---

What are the data movement modes in informatica?

1082

---

tell me the rules and responsblites in our project(my project is development)

1874

---

What is data movement mode in Informatica and difference between them?

1066

---