Answer / nag

Hi,

I hope this will work in SQL Transformation.

Thanks and Regards,

Nag

Answer / balanri

Expression Transformation of Informatica provides all kinds
of functions which also includes Userdefined functions. We
can also use defined variables in this.
Operators also included in this as functions.
Informatica Expression transformation provides this IN
Operator.

Answer / n.prasad

we can use In operator in source qualifier and sql
transformation if the source tables belongs oracle.otherwise
we cannot use in operator in informatica transformation.

Answer / sudha

I guess that the IN operator can used in Aggregator
transformation. Not sure if any know exact answer plz post..

Answer / sarat

IN is a n operator used to filter the records, that should participate in O/P or to be rejected.
So thats the reason, i think its Filter/Router

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

What is the need of etl tools?

0 Answers  

How can you complete unrcoverable sessions?

1 Answers  

Explain the flow of data in Iinformatica?

1 Answers  

How many repositories can be created in informatica?

1 Answers  

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

Write the program through which the records can be updated?

0 Answers  

What do you mean by filter transformation?

0 Answers  

Parameter and variable differences

0 Answers  

how to remove staging area

1 Answers  

What are the new features of informatica 7.1?

2 Answers