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 use batches?

0 Answers  

---

How do you remove duplicate records in informatica?

1 Answers  

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

What is a taget load order?

2 Answers   IBM,

---

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

Whats the difference between $, $$, $$$

9 Answers  

---

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

---

What does refresh system mean, and what are its distinctive choice?

0 Answers  

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---