Answer Posted / murali krishna

Transformations can be active or passive.

- An active transformation can change the number of rows
that pass through it, such as a Filter transformation that
removes rows that do not meet the filter condition.

- A passive transformation does not change the number of
rows that pass through it, such as an Expression
transformation that performs a calculation on data and
passes all rows through the transformation.

How many transformations can be used in mapplets.

1877

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2049

---

What are the settings that you use to configure the joiner transformation?

1003

---

r u done any partitions in ur project?

1755

---

Enlist the advantages of informatica.

1009

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1645

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2024

---

Explain incremental aggregation in informatica

1070

---

Explain sessions. Explain how batches are used to combine executions?

957

---

What do you mean by enterprise data warehousing?

1005

---

How do you promote a non-reusable transformation to reusable transformation?

1072

---

What are connected or unconnected transformations?

1053

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1509

---

What is a passive transformation?

1041

---

what is index?how it can work in informatica

1984

---