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

write sql query to remove null value following table
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma

i want the output

id name
101 dinesh
102 suresh
103 prakesh

Question Posted / dinesh

Answers were Sorted based on User's Feedback



write sql query to remove null value following table id name 101 dinesh null jyothi null bhar..

Answer / rama

select id, name from table where id is not null;

Is This Answer Correct ?    20 Yes 1 No

write sql query to remove null value following table id name 101 dinesh null jyothi null bhar..

Answer / gm

Rama you are correct.
In Additional For Informatica
S-SQ-FLT-TGT
FLT:
Condition
IIF(NOT ISNULL(ID),True,False)

Regards
GM

Is This Answer Correct ?    7 Yes 2 No

write sql query to remove null value following table id name 101 dinesh null jyothi null bhar..

Answer / hamza

delete id,name from tablename where id='null'

Is This Answer Correct ?    3 Yes 1 No

write sql query to remove null value following table id name 101 dinesh null jyothi null bhar..

Answer / reddy

Hi lakshmi in filter t/r in operator not supported,
GM Answer is good

Is This Answer Correct ?    0 Yes 0 No

write sql query to remove null value following table id name 101 dinesh null jyothi null bhar..

Answer / a.venkata lakshmi

select id,name from tablename where id in(101,102,103)

Is This Answer Correct ?    0 Yes 11 No

Post New Answer

More Informatica Interview Questions

What are the advantages of informatica?

0 Answers  

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

How to load relational source into file target?

3 Answers   IBM,

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

why we use materialized view over view?

1 Answers   Zensar,




where is the reject loader .

1 Answers  

What are the new features of informatica 9.x in developer level?

0 Answers  

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

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,

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

how to convert the .doc docs into .txt format using informatica

4 Answers  

in which situations do u go for snowflake schema ?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories