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

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

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,


What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,


According to his methodology what all you need before you build a datawarehouse

0 Answers  


scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  






What is a data modeling?

2 Answers  


Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


In a table, 4 person having same salary. How to get Third person record only?

15 Answers  


Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  


If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,


how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,


Can we update the data in flat file using update strategy?

3 Answers  


Categories