Answer Posted / manjunath

Stored procedure transformation is used to invoke the database procedure or function stored in the database. it needs the connection to the database. Where as the external procedure transformation is used to invoke the application function developed either in C/C++/VB.The external procedure needs to be bind with the external procedure transformation in the designer so the the application function would be loaded at the run time like a DDL.

What is meant by lookup transformation? Explain the types of lookup transformation?

579

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1715

---

What are the transformations that are not supported in mapplet?

610

---

What is meant by lookup transformation?

621

---

Is stop and abort are same in informatica?

576

---

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6413

---

What are the new features of informatica 9.x in developer level?

570

---

What are ETL Tools?

675

---

can you please explain me pre session and post session options?

6399

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1026

---

What is the difference between router and filter?

654

---

In how many ways we can create ports?

714

---

Explain how to import oracle sequence into informatica?

598

---

What are Dimensional table?

628

---

How can we handle two sessions in informatica?

627

---