write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

What is the sequence generator transformation in informatica?

0 Answers  

---

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

---

Define Incremental Aggregation?

2 Answers  

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

---

How can repository reports be accessed without sql or other transformations?

0 Answers  

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

what is the dashbords?

1 Answers   IBM,

---

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

1 Answers  

---

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---