Answer / rama

select id, name from table where id is not null;

Answer / gm

Rama you are correct.
In Additional For Informatica
S-SQ-FLT-TGT
FLT:
Condition
IIF(NOT ISNULL(ID),True,False)

Regards
GM

Answer / hamza

delete id,name from tablename where id='null'

Answer / reddy

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

Answer / a.venkata lakshmi

select id,name from tablename where id in(101,102,103)

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

Without source how to insert record to target?

6 Answers  

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.

0 Answers  

What is a surrogate key?

0 Answers  

What are the methods for creating reusable transforamtions?

2 Answers  

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

How we can create indexes after completing the loan process?

0 Answers  

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,

What are the components of the workflow manager?

0 Answers  

What is up date strategy and what are the options for update strategy?

2 Answers  

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,