write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

---

How can informatica be used for an organization?

0 Answers  

---

How will you convert rows into columns or columns into rows

1 Answers  

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

What is domain in terms of informatica?

0 Answers  

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

---

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

---

Difference between task flow and linear task flow

0 Answers  

---

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---