What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

What is a stored procedure 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,

---

Why do we need informatica?

0 Answers  

---

what is the difference between repository & Intergration service

1 Answers  

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

---

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

---

What is the function of look up transformation?

0 Answers  

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

What is power center repository?

1 Answers  

---