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
11362 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 is the format of informatica objects in a repository?

973

What is domain in terms of informatica?

953

What are the new features of Power Center 5.0?

1699

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

1075

Define filter transformation?

1031

what are the Methods For Creating Reusable Transformations?

1099

How to generate sequence numbers?

1029

How do you change a non-reusable transformation to reusable transformation?

942

What are the databases that informatica can connect to windows?

1001

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2293

Differentiate between source qualifier and filter transformation?

1509

What is primary and backup node?

1081

What are pre and post-session shell commands?

1236

Explain the features of connected and unconnected lookup.

875

How do you load first and last records into target table?

1099