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
- 9952 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
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 |
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?
Target increases every day even though no new record was inserted
What is data caches/ index caches?
What is the difference between stop and abort in informatica
How to generate sequence numbers using expression transformation?
What is meant by active and passive transformation?
Separate from an archive server and a powerhouse?
What are the main issues while working with flat files as source and as targets ?
COM components can be used in Informatica
What is a code page?
What is a router transformation?
What is pmcmd command?
Which are the different editions of informatica powercenter that are available?
Under what condition selecting sorted input in aggregator may fail the session?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
