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 can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

How does the aggregator transformation handle null values?

0 Answers  

---

What is DR strategy for Informatica project?

0 Answers  

---

What are two types of processes that informatica runs the session?

2 Answers  

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

What is the scenario which compels informatica server to reject files?

0 Answers  

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

how do u move the code from development to production?

3 Answers  

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

---

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

---

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

---

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

---