Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6142 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / subbu
select * from table name where name is not null and
age is not null
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
Explain the types of lookup transformation?
what is the complex transformation you used in informatica
Mention some types of transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the different lookup cache(s)?
What is persistent lookup cache?
I have a flat file, want to reverse the contents of the flat file
Difference between Target-based loading and constraint-based loading?
What are the types of caches in lookup? Explain them.
Why filter transformation is an active one?
What are the components of workflow manager?
What is meant by a domain?
Design time, run time. If you don't create parameter what will happen
What is sorter transformation?
What is a node in Informatica?
