write a query to remove null value follwing table?
col1 col2 col3
dinesh null null
null suresh null
null null prakesh
i want the output
col1 col2 col3
dinesh suresh prakesh
Answer Posted / chandrasekar
Hi Srinivas how the sql query execute because the query
returns only max values.. so please clarify.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
waht type of interface is used for testing the data in informatica
What is the need for an etl tool?
What do you understand by a term domain?
What are the different versions of informatica?
Global and Local shortcuts. Advantages.
Explain dynamic target flat file name generation in informatica
What is incremental aggregation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is standalone command task?
What is a joiner transformation and why it is an active one?
Is stop and abort are same in informatica?
Could you explain what is enterprise data warehouse?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How do you load alternate records into different tables through mapping flow?
What are the different types of transformation available in informatica.