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 difference between a router and a filter transformation?

1 Answers   TCS,

---

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---

can anyone suggest best free Talend data integration training online

0 Answers  

---

What is DTM process?

4 Answers  

---

What are the session parameters?

3 Answers  

---

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

can we generate reports in informatica ? How?

3 Answers  

---

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

---

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

---

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---