Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What are two types of processes that informatica runs the session?

2 Answers  


how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,


Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,


What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,


How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  


Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,


In Which scenario did u used Incremental loading?

2 Answers  


i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,


can session assigned multiple mappings or not?

2 Answers   Zensar,


Reusable transformation and shortcut differences

0 Answers  


Categories