I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

what is dimension table?

17 Answers  

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---

What is facttable granularity?

2 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

what is Active lock explain

0 Answers   Satyam,

---