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
What are mapplets?
What can we do to improve the performance of informatica aggregator transformation?
What does command task mean?
How to use pmcmd utility command?
Define pmcmd command?
What is the commit type if you have a transaction control transformation in the mapping?
What is the surrogate key?
What is workflow? What are the components of the workflow manager?
Briefly describe lookup transformation?
What are the components of the workflow manager?
what is diff b/t sorter t/r and agg have the option sorter property...
Is there any target staging area in informatica not staging area
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Differentiate between sessions and batches?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?