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)

what is runtime variable?

3 Answers   TCS,

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

What is source qualifier?

6 Answers   SDS,

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

what is left outer join?

3 Answers   L&T,

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

What are ETL Tools?

0 Answers   Informatica,

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

what are the row and column separations in Flat Files

3 Answers   CTS,

What is lookup change?

0 Answers  

What are the two modes of datamovement in informatica sever?

2 Answers