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
- 9693 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 |
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
Plz..let me know differences between Informatica 7.1 and 8.1?
What is meant by LDAP users?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
why we use datawarehouse
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
4 yrs etl devloper roles and responsibilities?any body give solutions
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
where does the default group roew in a router is stored what is the default size of memory in router
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
Teradata 
