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
- 5244 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
To import the flat file definition into the designer where should the flat file be placed?
What are the different types of transformation available in informatica.
What is fact table? Explain the different kinds of facts.
how many types of dimensions are available in informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to implement security measures using repository manager?
Is it possible to revert a global repository to local one and why?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
tell me the rules and responsblites in our project(my project is development)
What you know about transaction control transformation?
Can we create multiple integration service on single repository?
Performance tuning in UNIX for informatica mappings?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
