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 metadata?

8 Answers   Satyam,

Can i create a lookup table without cache.

7 Answers   iGate,

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

What is a predefined event?

0 Answers  

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

Explain pmcmd command usage in informatica

0 Answers   Informatica,

When the informatica server marks that a batch is failed?

1 Answers  

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

List the transformation in informatica.

1 Answers   TCS,