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
- 9819 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
what is the size of your data warehousing?
What does update strategy mean, and what are the different option of it?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How can you validate all mappings in the repository simultaneously?
what is $$$$?
What is the difference between router and filter?
How to update or delete the rows in a target, which do not have key fields?
Which is the t/r that builts only single cache memory?
Explain the different kinds of facts.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How are the sources and targets definitions imported in informatica designer?
where to store informatica rejected data? How to extract the informatica rejected data?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Can you use flat files in Mapplets.
