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 list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

comonly how meny mappings r there in Banking projects?

1 Answers  

What is the different lookup cache(s)?

0 Answers  

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

What are pre and post-session shell commands?

0 Answers  

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

What is the procedure to load the fact table.Give in detail?

1 Answers  

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,