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
- 6020 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / karthis4u
select * from table name where name is not null OR
age is not null
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is persistent lookup cache?
Explain the different kinds of facts.
What is a snowflake schema?
How to differentiate between the active and passive transformations?
Why update strategy and union transformations are active? Explain with examples.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What does refresh system mean, and what are its distinctive choice?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Differentiate between Load Manager and DTM?
What is workflow monitor?
What is status code in informatica?
Explain dynamic target flat file name generation in informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Differentiate between sessions and batches?
