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,

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---

What are the different threads in DTM process?

2 Answers  

---

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

---

What is standalone command task?

1 Answers  

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

Explain the features of connected and unconnected lookup.

1 Answers  

---