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
- 8445 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 is DR strategy for Informatica project?
Which development components of informatica have the highest usage?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is data caches/ index caches?
write a query to retrieve the latest records from the table sorted by version(scd)
What is primary and backup node?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
explain one complex mapping with logic? sales project?
What are the restrictions of union transformation?
How to load data in informatica ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is meant by incremental aggregation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Clarify the utilization of aggregator cache record?
Differentiate between joiner and lookup transformation?
