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)

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

Can you create a flatfile target

3 Answers   ABC,

explain about lookup t/r?

1 Answers   IBM,

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

Define mapping and session?

0 Answers   Informatica,

Why do we need informatica?

0 Answers  

In which circumstances that informatica server creates Reject files?

2 Answers  

what is Active lock explain

0 Answers   Satyam,