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
- 9798 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / srinivas kondeti
SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE_NAEM
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
update strategy transformation in informatica
Sequence generator, when you move from develoment to production how will you reset
What is the difference between stop and abort in informatica
What are the new features of Power Center 5.0?
Different sorts of metadata that stores in the storage facility?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How would you copy the content of one repository to another repository?
What is mapplet in informatica?
What are the different options available for update strategy?
How union transformation is used?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the performance considerations when working with aggregator transformation?
Partition, what happens if the specified key range is shorter and longer
How do you promote a non-reusable transformation to reusable transformation?
What is joiner transformation in informatica?
