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
- 9662 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
Explain dynamic target flat file name generation in informatica
What is flashback table ? Advance thanks
what is the hint? how to use it to reduce the query processing in program?
What is the meaning of up gradation of repository?
what is the size of u r source(like file or table)?
How to update or delete the rows in a target, which do not have key fields?
What are different types of transformations available in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
How to improve the performance of a session using sorter transformation?
How can we delete duplicate rows from flat files?
my source is junk data how will u remove that junk data by using unix please any one replay me
How identifying bottlenecks in various components of informatica and resolving them?
How can we remove the duplicates from flat file source?
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 are the types of lookup transformation?
