COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: templa73 on 26 Mar 2011 11:32:35 AM

Title: Merge Or aggregate records
Post by: templa73 on 26 Mar 2011 11:32:35 AM
Hi
I'm beginner with datamanager and please could some one explain to me the difference between:
-Aggregate records with duplicate key and
-Merge records with duplicate key.


And when can we use one aggregate instead of Merge?

Thanks for all
Title: Re: Merge Or aggregate records
Post by: MFGF on 12 May 2011 09:06:02 AM
Aggregation is the process of rolling measures up the levels of a dimensional hierarchy.  Merging is the process of consolidating duplicate rows on input, based on the rows having the same combination of dimensional keys.

Regards,

MF.