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

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

What is dynamic cache?

0 Answers  

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

What are the differences between oltp and olap?

0 Answers  

when informatica 8 series released ?

1 Answers   IBM,

how to join two flat files in informatica?

3 Answers   Wipro,

Can we create a Integration service without a Repository service and vice versa?

0 Answers  

In a sequential batch can you run the session if previous session fails?

4 Answers  

Two Default User groups created in the repository are ____ and ______

2 Answers  

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

what is materialized view?

2 Answers  

How are indexes created after completing the load process?

0 Answers