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
- 9144 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
How to load last n records of file into target table - informatica
What is sorter transformation?
What is a sorter transformation?
Explain the informatica workflow?
What is decode in informatica?
What do you mean by blocking transformation?
How are indexes created after completing the load process?
What are Dimensional table?
Explain what are the different types of transformation available in informatica.
What is a mapplet/worklet in informatica?
Is stop and abort are same in informatica?
What is deployment group?
Differences between version 7.x and 8.x.
What is exclusive and normal mode for repository services?
What is mapplet in informatica?
