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

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

What is confirmed dimension with scenario

1 Answers   HCL,

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,




what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

2 Answers   Deloitte, TCS,

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

What is source qualifier?

6 Answers   SDS,

For more Informatica Interview Questions Click Here
Categories