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

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers Syntel,

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers

why we need informatica

2 Answers HCL,

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers HP, Patni,

Which transformation should u need while using the cobol sources as source defintions?

2 Answers

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers IBM,

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers

what is $$$$?

0 Answers TCS,

whats the logic to load the lower level of granularity of data to fact table.

0 Answers IBM,

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers

how to remove staging area

1 Answers

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers TCS,

For more Informatica Interview Questions Click Here