In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,

---

How can repository reports be accessed without sql or other transformations?

0 Answers  

---

what is correlated query?

2 Answers   IBM,

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

---

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

---

How i can upload the MainFrame source For Informatica ?

1 Answers  

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

why do u use shortcuts in informatica.?

4 Answers   iFlex,

---

What is the difference between a connected look up and unconnected lookup?

0 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---