Answer / abhinaw prakash

When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes incrementally and you can
capture changes, you can configure the session to process
those changes. This allows the Integration Service to update
the target incrementally, rather than forcing it to process
the entire source and recalculate the same data each time
you run the session.

For example, you might have a session using a source that
receives new data every day. You can capture those
incremental changes because you have added a filter
condition to the mapping that removes pre-existing data from
the flow of data. You then enable incremental aggregation.

When the session runs with incremental aggregation enabled
for the first time on March 1, you use the entire source.
This allows the Integration Service to read and store the
necessary aggregate data. On March 2, when you run the
session again, you filter out all the records except those
time-stamped March 2. The Integration Service then processes
the new data and updates the target accordingly.

Answer / kunkala.ramakrishna

IF THE SOURCE CHANGES ONLY INCREMENTLY AND U CAN CAPTURE THOSE CHANGES

YOU CAN CONFIGURE THE SESSION TO PROCESS ONLY THOSE CHANGES

What are mapplets?

0 Answers  

---

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

---

which one is better performance wise joiner or look up

0 Answers   Informatica,

---

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,

---

How the dimensions will be loaded?

0 Answers   HCL,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---

What is a pre-defined event and user-defined event?

0 Answers  

---