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.

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

---

Differentiate between joiner and lookup transformation?

0 Answers  

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

---

what is data driven in informatica

5 Answers   IBM,

---

What are the new features of informatica 9.x at the developer level?

0 Answers  

---

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

---

What are Business Components in Informatica?

1 Answers  

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

---