Answer / guest

In view we cannot do DML commands where as it is possible
in Materialized view.

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,

---

How to go to the older version for a mapping?

0 Answers  

---

what is size of u r database?

0 Answers  

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---