how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 22118 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 do you mean by blocking transformation?
What is the sql query overwrite in source qualifier in informatica
What are the tuning techniques you applied during your last project
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explian the Process of deployment groups in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How big was your fact table
What is event and what are the tasks related to it?
Define filter transformation?
Enterprise data warehouse your projects phase by phase explain?
how we can load rejected record's at run time?(not through bad files)
where to store informatica rejected data? How to extract the informatica rejected data?
What is meant by query override?
How might you approve all mappings in the archive all the while?
