Query on GIM and interactive Insight

General Discussion
1

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,

2

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.

3 Likes
3

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

Thnks,

1 Like
4

ummm…

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

1 Like
5

Thanks Franklin.
Got the picture now.

6

:wink: