I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

What is decode in informatica?

0 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

---

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

how many session run unix environment what command using ?

1 Answers   HCL,

---

What is session task and command task?

0 Answers  

---

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

---