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

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

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,


without using rank transformation how can we rank items by using some other transformations

2 Answers  


What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  


1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,


What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  






there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,


How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  


Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,


What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,


How to load a relational source into file taget?

2 Answers  


Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,


Categories