write sql query to filter the null value data following table? name age joh

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

2 Answers
5283 Views
HP, I also Faced
E-Mail Answers

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

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers Wipro,

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers Cognizant, IBM,

What is a command that used to run a batch?

2 Answers

What is transformation?

0 Answers

What is Cognos script editor?

0 Answers Cognizant,

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers IBM,

how to remove staging area

1 Answers

what r the values tht r passed between informatics server and stored procedure?