Hi lakshmi in filter t/r in operator not supported, GM Answer is good

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

Question Posted / reddy

5 Answers
11623 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

Please Help Members By Posting Answers For Below Questions

What differs when we choose the sorted input for aggregator transformation?

1034

how to load rows into fact table in data warehouse

1199

Performance tuning in UNIX for informatica mappings?

2575

write a query to retrieve the latest records from the table sorted by version(scd)

1076

COM components can be used in Informatica

2401

What is resilience time?

1156

server hot-ws270 is connect to Repository B. What does it mean?

2573

difference between informatica 8.1.1 and 8.6

3683

What is the difference between a repository server and a powerhouse?

1521

What is a sorter transformation?

1109

What is incremental aggregation?

1091

What is pmcmd command?

1132

What is sorter transformation?

1057

Explain what transformation and how many are there in informatica?

961

What is a grid in Informatica?

1080