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

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 / rama

5 Answers
11364 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / rama

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

Is This Answer Correct ?

20 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we remove the duplicates from flat file source?

948

What is the difference between stop and abort in informatica

1042

What is an active transformation?

1037

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

2021

How does the aggregator transformation handle null values?

1085

How can we store previous session logs?

989

What is the use of transformation?

945

What do you mean by filter transformation?

903

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1506

Explain pmcmd command usage in informatica

1065

Please let me know how to make encryption and decryption with example?

1847

How many ways a relational source definition can be updated and what are they?

953

Is stop and abort are same in informatica?

947

Explain the pipeline partition with real time example?

1083

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

1926