Rishi

• Dec 5th, 2005

 

It depends upon our requirment only.If you have good processing database you can create aggregation table or view at database level else its better to use informatica. Here i'm explaing why we need to use informatica.

what ever it may be informatica is a thrid party tool, so it will take more time to process aggregation compared to the database, but in Informatica  an option we  called "Incremental aggregation" which will help you to update the current values with current  values +new values. No necessary to process entire values again and again. Unless this can be done if nobody deleted that cache files. If that happend total aggregation we need to execute on informatica also.

In database we don't have Incremental aggregation facility.

prasadns26

 Profile Answers by prasadns26 

• Jul 18th, 2006

 

hi,

see informatica is basically a integration tool.it all depends on the source u have and ur requirment.if u have a EMS Q, or flat file or any source other than RDBMS, u need info to do any kind of agg functions.

if ur source is a RDBMS, u r not only doing the aggregation using informatica right?? there will be a bussiness logic behind it. and u need to do some other things like looking up against some table or joining the agg result with the actual source. etc...

if in informatica if u r asking whether to do it in the mapping level or at DB level, then fine its always better to do agg at the DB level by using SQL over ride in SQ, if only aggr is the main purpose of ur mapping. it definetly improves the performance.