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
- 9211 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / sasibushan
This will work
SELECT Max(CASE WHEN col1 IS NOT NULL THEN col1 END) AS "col1",
Max(CASE WHEN col2 IS NOT NULL THEN col2 END) AS "col2",
Max(CASE WHEN col3 IS NOT NULL THEN col3 END) AS "col3"
FROM Table_name
Convert this logic to Informatica...
Sasi.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the advantage of informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What do you mean incremental aggregation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What does refresh system mean, and what are its distinctive choice?
how we can load rejected record's at run time?(not through bad files)
What are ETL Tools?
Explain joiner transformation in informatica
What are the guidelines to be followed while using union transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is persistent lookup cache?
Plz can any one say me how to get the informatica certification materials and dumps
What are the various types of transformation?
Can u generate reports in Informatica?
