Interested to Buy Any Domain ? << Click Here >> for more details...
write sql query to remove null value following table
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma
i want the output
id name
101 dinesh
102 suresh
103 prakesh
- 5 Answers
- 11567 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / reddy
Hi lakshmi in filter t/r in operator not supported,
GM Answer is good
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where do we use mapping variables in informatica?
How will the document be delivered to me?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
what are the Methods For Creating Reusable Transformations?
What is a repository? And how to add it in an informatica client?
What is the difference between a connected look up and unconnected lookup?
Can u generate reports in Informatica?
How do you load only null records into target? Explain through mapping flow.
How to configure mapping in informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Is it possible to create multiple domains on a single Informatica server?
Differences between connected and unconnected lookup?
What does command task mean?
What is joiner change?
What is event and what are the tasks related to it?
