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.

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

---

What is informatica metadata and where is it stored?

0 Answers  

---

How will you convert rows into columns or columns into rows

1 Answers  

---

how to join two flat files in informatica?

3 Answers   Wipro,

---

what is left outer join?

3 Answers   L&T,

---

What are connected or unconnected transformations?

0 Answers   Informatica,

---

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

0 Answers   Cognizant, Flextronics,

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---