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,

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

---

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

---

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

---

Whats there in global repository

0 Answers  

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

---

How to use procedural logic inside infromatica?

0 Answers  

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---