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
- 11619 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gm
Rama you are correct.
In Additional For Informatica
S-SQ-FLT-TGT
FLT:
Condition
IIF(NOT ISNULL(ID),True,False)
Regards
GM
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / reddy
Hi lakshmi in filter t/r in operator not supported,
GM Answer is good
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / a.venkata lakshmi
select id,name from tablename where id in(101,102,103)
| Is This Answer Correct ? | 0 Yes | 11 No |
What is the difference between warehouse key and surrogate key?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What are the differences between joiner transformation and source qualifier transformation?
What are the transformations that are not supported in mapplet?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How can we create index after completion of load process?
What is deployment group?
Global and Local shortcuts. Advantages.
What are batches?
task is running successfully but data is not loded why?
what is diff between grep and find
Teradata 
