Answer Posted / srinivasulu raju

It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...

Condition: Source must be DataBase.

How can a transformation be made reusable?

1163

---

Make a note of the quantity vaults made in informatica?

988

---

COM components can be used in Informatica

2385

---

What do you mean by channel change?

1041

---

how to load dimension table and fact table. plz tell me the steps.

2092

---

Mention few advantages of router transformation over filter transformation.

1021

---

What is incremental aggregation?

1079

---

What are active and passive transformations?

1079

---

Can informatica load heterogeneous targets from heterogeneous sources?

1183

---

how to create user defined function (udf) in informatica

1301

---

What is a joiner transformation and why it is an active one?

1077

---

What is union transformation in informatica?

1146

---

what is the difference between informatica6.1 and infomatica7.1

2271

---

wat are deployement groups in informatica, how it will be used for developers

1717

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

---