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
- 9824 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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are active transformations.
What is workflow? What are the components of the workflow manager?
How do you load first and last records into target table?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
whats the logic to load the lower level of granularity of data to fact table.
Explain the types of transformations?
What is the sequence generator transformation in informatica?
What are the different types of transformation available in informatica.
what is Active lock explain
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the differences between a connected lookup and unconnected lookup?
How to load data in informatica ?
What is informatica? Why do we need it?
What is the meaning of decode in informatica?
