Interested to Buy Any Domain ? << Click Here >> for more details...
how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 23891 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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the types of schemas we have in data warehouse.
What is domain and gateway node?
Write the different tools in the workflow manager?
have u done any performance tuning? how u ll do?
What is complex mapping?
How to generate sequence numbers using expression transformation?
What is native users?
What will be the approach?
What is Index Caches size?
What is standalone command task?
generate date / time dimension in informatica
Explain the different dimensions.
What is transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
