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
- 9867 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
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What do mean by local and global repository?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
what is unit testing?tell me proceedure
can we override a native sql query within informatica? How do we do it?
What is parallel processing in informatica?
What are the components of the workflow manager?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How to generate sequence numbers without using the sequence generator transformation?
What are the databases that informatica can connect to windows?
which one is better performance wise joiner or look up
How to delete duplicate row using informatica?
Mention some types of transformation?
What are pre and post-session shell commands?
On which transformations you created partitions in your project?
