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
6015 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

explain one complex mapping with logic? sales project?

0 Answers Accenture, JPMorgan Chase,

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers CTS,

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers

what is flat file override?

1 Answers Cap Gemini, HP,

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers TCS, Wipro,

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers

How the informatica server increases the session performance through partitioning the source?

1 Answers

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers Amdocs,

Explain the shared cache and re-cache?

0 Answers

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers Amex,

What are Rapid changing dimensions?

1 Answers

What is difference between maplet and reusable transformation?

2 Answers

For more Informatica Interview Questions Click Here