Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: sunbabu15 on February 04, 2011, 06:16:45 PM

Title: Query on GIM and interactive Insight
Post by: sunbabu15 on February 04, 2011, 06:16:45 PM

Hi ALL,

Can any one please summarize in brief what exactly the FACT ,Dimension and Aggregate tables refers n used in Infomart DB.
I  have gone through the Genesys docs but couldn't get the clear picture on this .

Thanks,

Title: Re: Query on GIM and interactive Insight
Post by: fnunezsa on February 04, 2011, 06:30:29 PM

Do you understand what a Star Schema is?

In a star schema you have some fact tables that store some "facts" or data that refers to some "dimension".

The aggregates tables are optional tables that store some "aggregated facts". For example total number of interactions handled by agents or group of agents in a specified period of time. In the previous example, "total number of interactions" is an aggregated fact and "agents" or "group of agents" are dimensions.

HTH,

Kind regards,
Franklin.

Title: Re: Query on GIM and interactive Insight
Post by: sunbabu15 on February 04, 2011, 06:34:39 PM

Hi Franklin,
Sorry. I still didn't get you.
Can you please explain in brief wht fact and dimension and Star Schema refers ?

Thnks,

Title: Re: Query on GIM and interactive Insight
Post by: fnunezsa on February 04, 2011, 07:27:34 PM

ummm...

Please refer to http://en.wikipedia.org/wiki/Star_schema

Title: Re: Query on GIM and interactive Insight
Post by: sunbabu15 on February 05, 2011, 06:01:41 AM

Thanks Franklin.
Got the picture now.

Title: Re: Query on GIM and interactive Insight
Post by: fnunezsa on February 08, 2011, 01:12:28 AM

;)