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
- 4 Answers
- 9186 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
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 is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
update strategy transformation in informatica
What are the types of schemas we have in data warehouse.
How many ways a relational source definition can be updated and what are they?
Different circumstance which drives informatica server to expel records?
What are the advantages of using informatica as an etl tool over teradata?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a mapplet/worklet in informatica?
Enlist few areas or real-time situations where informatica is required.
Where is metadata stored?
What does role playing dimension mean?
What is the use of an aggregator cache file?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Do you find any difficulty while working with flat files as source and target?
