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 the difference between informatica 8.x and 9.x

1 Answers   Wipro,

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

What is dynamic cache?

0 Answers  

What is exclusive and normal mode for repository services?

0 Answers  

What is the need of building a data warehouse?

2 Answers  

what are surrogate keys?

5 Answers  

how to work with mapplet designer in informatica?

7 Answers  

Name the different lookup cache(s)?

0 Answers  

What do you mean by channel change?

0 Answers  

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

In warehouses how many schemas are there?

0 Answers  

What are variable ports and list two situations when they can be used?

1 Answers