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
- 9802 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / hamza
delete id,name from tablename where id='null'
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the main issues while working with flat files as source and as targets ?
define galaxy repository in informatica
what are the deliverables?in your project?
What is an expression transformation?
Why update strategy and union transformations are active?
What is standalone command task?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is rank index in rank transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is informatica? Why do we need it?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the commit type if you have a transaction control transformation in the mapping?
How might you approve all mappings in the archive all the while?
How does a sorter cache works?
