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

What is different between the data warehouse and data mart?

0 Answers  

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

What is Target Update Override? What is the Use ?

8 Answers   Patni,

---

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

---

---

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

When the informatica server marks that a batch is failed?

2 Answers  

---

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---