1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

How union transformation is used?

0 Answers  

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

what is the difference between onsite & client site?

1 Answers  




Why is sorter an active transformation?

0 Answers  

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

Insert else update option in which situation we will use

4 Answers   HCL,

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories