how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 20933 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
You have to perform the Incremental Aggregation in Session
Properties only.
Ex:-
You Target Table loaded(with Agg Caluclation) 100 Records
on yesterday ,
Now newly you have 50 Records(25 update,25 insert),
To done the Agg calculation for Updated Records ,Insert
Records you need to
Perform Incremental Aggregation.This is simple way to
increase the Performance,
Redusing the time etc.
If you not perform the Incremental Aggregation, you can
do the same thing
In another way.But it’s lenthy.
Any ??? or Corrections,,let me
know ‘Srinu.srinuvas@gmail.com ‘
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
Can you use flat files in Mapplets.
Explain informatica architecture - version 8 / 9
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the session task and command task?
How to improve the performance of a session using sorter transformation?
What is incremental aggregation?
How can we use batches?
How to do unit testing in informatica? How to load data in informatica ?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is Data Caches size?
Can we create two repositories on same database instance in oracle?
What happens when a session fails and you click on recover?
What are the components of the workflow manager?
Sequence generator, when you move from develoment to production how will you reset
