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
- 9120 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas kondeti
SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE_NAEM
| Is This Answer Correct ? | 11 Yes | 1 No |
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 |
Answer / 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 |
Answer / rahul
In Informatica use aggrigator on group by Col1 Col2 Col3.
| Is This Answer Correct ? | 2 Yes | 2 No |
Why filter transformation is an active one?
in which situations do u go for snowflake schema ?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
Difference between task flow and linear task flow
Define update strategy?
How will you combine 3 different sources with a single source?
How will u pas the data with out debugger?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
What are the challenges you have faced in your project?
Is it possible to revert a global repository to local one and why?
Teradata 
