Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9687 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 are the components of workflow manager?
What is data movement mode in Informatica and difference between them?
Explain the scenario which compels informatica server to reject files?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is a filter transformation and why it is an active one?
What is depict expression change?
Enlist some properties of sessions.
What is aggregator transformation in informatica?
Explain pushdown optimization and types in informatica
Explain sessions and how many types of sessions are there?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is mapping debugger?
What is aggregate cache in aggregator transformation?
How do you handle two sessions in Informatica
whats the logic to load the lower level of granularity of data to fact table.
