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 Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

Describe an informatica powercenter?

0 Answers  

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

Parameter and variable differences

0 Answers  

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers