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.

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

Differentiate between sessions and batches?

0 Answers  

---

Name 4 output files that informatica server creates during session running?

1 Answers  

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

What is parameter file?

2 Answers  

---

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

what is unique constraint error ?

2 Answers   TCS,

---

what is materialized view?

2 Answers  

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---