Answer / ajay konidena

if u have full of experience and knowledge in plsql some of
the thing we can do with informatica tool we can also do
with plsql language

Answer / yours

Having a good SQL and PL/SQL knowledge is very important..that knowlege is helpful while your a developer..

Answer / raj

Stored Procedures and functions

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---

How to implement security measures using repository manager?

0 Answers  

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

What is a sequence generator transformation?

0 Answers  

---

how to delete duplicate records by using filter transfermation?

3 Answers  

---

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

How to view and Generate Metadata Reports?

1 Answers  

---

Describe expression transformation?

0 Answers  

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---