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,

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

---

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

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

2 Answers   TCS,

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

What are the differences between oltp and olap?

0 Answers  

---

What is meant by incremental aggregation?

0 Answers  

---