write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---

Why you use repository connectivity?

3 Answers   Yash Technologies,

---

what is the function of 'F10' informatica ?

4 Answers   IBM,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

explain about unit testing? in real time?

0 Answers   L&T,

---

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

---

What is transformation?

0 Answers  

---

"Change cache" in Informatica ?

2 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

In a sequential batch can u run the session if previous session fails?

3 Answers  

---