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
- 11778 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / a.venkata lakshmi
select id,name from tablename where id in(101,102,103)
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
What is a repository? And how to add it in an informatica client?
Name the different lookup cache(s)?
What is a surrogate key?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the measure objects?
How do you convert single row from source into three rows into target?
Define mapping and session?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
tell me the rules and responsblites in our project(my project is development)
What is the function of look up transformation?
Which transformation should we use to normalise the COBOL and relational sources?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the informatica performance improvement tips
