I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: 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

2 Answers   IBM,

---

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,

---

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

What is Cognos script editor?

0 Answers   Cognizant,

---

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,

---

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

Tell me about Propagate functions in informatica

0 Answers  

---

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

---

how to join two flat files in informatica?

3 Answers   Wipro,

---

What is a transaction control transformation?

0 Answers   Informatica,

---