Interested to Buy Any Domain ? << Click Here >> for more details...
how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 23249 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
What is the session task and command task?
What is Index Caches size?
How to load last n records of file into target table - informatica
How to generate sequence numbers without using the sequence generator transformation?
What is meant by active and passive transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What do you mean by worklet?
What is incremental aggregation?
how to load dimension table and fact table. plz tell me the steps.
What is a mapplet/worklet in informatica?
What happens when a session fails and you click on recover?
What is the difference between a repository server and a powerhouse?
permutations of mapplet
What are the types of presistent cache in look up tr.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
