Answer / ranjan

in incremental aggregation only the captured changes will be
considered for aggregate calculation i.e. when new data will
be inserted for calcutation , informatica power center
server will not start the processing from the begining .

Answer / lokendra

The first time you run an incremental aggregation session,
the PowerCenter Server processes the entire source. At the
end of the session, the PowerCenter Server stores aggregate
data from that session run in two files, the index file and
the data file. The PowerCenter Server creates the files in
a local directory.

Each subsequent time you run the session with incremental
aggregation, you use only the incremental source changes in
the session.

Types of error logs in Informatica?

2 Answers  

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

---

What is repository manager?

0 Answers  

---

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

What is staging area?

11 Answers  

---

What is expression transformation?

0 Answers  

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

How you prepared reports for OLAP?

0 Answers  

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---