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
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
What is the function of look up transformation?
Is it possible to create multiple domains on a single Informatica server?
What do you mean by blocking transformation?
What is the fact table?
During the running session, output files are created by informatica server. Enlist few of them.
What is complex mapping?
How many types of sessions are there in informatica.please explain them?
What are the databases that informatica can connect to windows?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is enterprise data warehousing?
What are the new features of Power Center 5.0?
What are the components of Informatica? And what is the purpose of each?
What is the difference between a connected look up and unconnected lookup?
How many dimensions are there in informatica?
What is InformaticaPowerCenter?