Rama you are correct. In Additional For Informatica S-SQ-FLT-TGT FLT: C

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 / gm

5 Answers
11780 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does a rank transform differ from aggregator transform functions max and min?

1262

what are the deliverables?in your project?

2194

Performance tuning in UNIX for informatica mappings?

2623

r u done any partitions in ur project?

1862

What is informatica?

1218

What is the reusable transformation?

1100

What are the tasks that source qualifier perform?

1145

What is dynamic cache?

1085

What are the differences between oltp and olap?

1017

What is a predefined event?

1134

Briefly define reusable transformation?

1180

What are the tasks that can be performed using sq?

1140

What is flashback table ? Advance thanks

1997

Is it possible to create multiple domains on a single Informatica server?

1288

How to Create a folder using pmrep command?

1221