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
11587 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 are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1071

Define mapplet?

1006

where to store informatica rejected data? How to extract the informatica rejected data?

1002

What is rank transform?

993

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1261

how to load dimension table and fact table. plz tell me the steps.

2092

Quickly characterize reusable change?

1117

What is the difference between informatica 7.0 and 8.0?

1011

What are the data movement modes in informatica?

1147

can we override a native sql query within informatica? Where do we do it?

1116

Enlist the various types of transformations.

1052

Could you explain what is enterprise data warehouse?

1138

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1701

Is it possible to use a client with different version than that of its Informatica server?

1134

What are the types of caches in lookup?

1048