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
- 9660 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 |
how we do performence tuning in informatica
what are the differences between powercenter 8.1 and powercenter 8.5?
Explain the shared cache and re-cache?
What are limitations of joiner transformation?
In a sequential batch can you run the session if previous session fails?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
What is IQD file?
What is status code in informatica?
What are differences between Informatica 7.1 and 6.1
Which transformation should we use to normalise the COBOL and relational sources?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
Teradata 
