Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 11607 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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the new features of informatica 9.x developer?
What is a grid in Informatica?
Can u generate reports in Informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is meant by incremental aggregation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the tuning techniques you applied during your last project
How do you load only null records into target? Explain through mapping flow.
Why sorter is an active transformation?
What is the need of etl tools?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
can u any challenge your project?
explain abt ur project architecture?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
