1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / dinesh

Answers were Sorted based on User's Feedback



write sql query to filter the null value data following table? name age john 30 smith null n..

Answer / subbu

select * from table name where name is not null and
age is not null

Is This Answer Correct ?    17 Yes 2 No

write sql query to filter the null value data following table? name age john 30 smith null n..

Answer / karthis4u

select * from table name where name is not null OR
age is not null

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

what is data driven?

5 Answers   TCS, Wipro,

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  




What are the types of groups in Router transformation?

1 Answers   Informatica,

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 are the modules in Power Center

0 Answers  

r u done any partitions in ur project?

0 Answers   TCS,

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

What are the rank caches?

2 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories