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.

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

---

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

Briefly define a session task?

0 Answers  

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

---

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---