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,

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

what is bridge tables in informatica

1 Answers   CTS,

---

How the informatica server increases the session performance through partitioning the source?

1 Answers  

---

How to recover sessions in concurrent batches?

1 Answers  

---

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

---

Explain reference cursor?

1 Answers  

---

what is mapping parameter?

2 Answers   Cap Gemini,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

What is informatica etl tool?

0 Answers  

---