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,

---

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

---

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

---

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

---

Explain the types of lookup transformation?

0 Answers  

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

How big was your fact table

0 Answers  

---

What is dimensional table? Explain the different dimensions.

0 Answers  

---