Answer Posted / srikanth

HI

Among those 3 trans, filter does not use cache.

so it should be either agg or sorter.

Both agg and sorter uses cache as they process data in a
dependable fashion for performing calculations and sorting
data before the result is passed to next transfomration.

WE cant say which one uses more space. it depends on the
size of source data we are processing.

Agg needs to perform calculations on groups of data but if
the data in sorter is more, it takes more space than agg to
hold the data.

for ex, we are sorting on character data, server needs to
use ASCII values of alphabets to sort in order.

It depends on the size of the source data.

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1744

---

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

1729

---

What are the guidelines to be followed while using union transformation?

635

---

What is lookup transformation?

587

---

Enterprise data warehouse your projects phase by phase explain?

1453

---

---

How we can create indexes after completing the load process?

607

---

What are some examples of informatica etl programs?

529

---

Did u used latest transformations of 8.6.0? for what?

1471

---

How can we use mapping variables in informatica?

595

---

What is the Rank index port in Rank transformation?

666

---

What are pre and post-session shell commands?

735

---

What is fact table? Explain the different kinds of facts.

610

---

Explain what transformation and how many are there in informatica?

480

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1743

---

What are the different components of powercenter?

578

---