Hello,

I understand that a Datamart is just another database, which its data
is aquired from source systems - which are transactional system. This
kind of aquiring is called "reconciled".

At the end, a datamart is actually another database from where is
needed to get information via queries.

There would be 2 differences between a datamart and a transactional
standard system:

1. Users could make queries without a programmer's help.
2. The datamart is constructed in a different way. I suposse that a
datamart has rows, columns and tables like any transacctional
database, but the difference is the way the data is "reconciled". I
would think that the entry data is saved just as a concised data. It
means, it is the result of several previuos calculations. And there's
no user who feed the datamart. A datamart is feeded by transactional
standard systems.

My question would be:
1) Am I correct?
2) Is it possible to have a datamart without a transaction source
system? Could you show me an example?

Thanks indeed
Jorge

"Jorge_Beteta" <jbeteta (AT) yahoo (DOT) com> wrote


Not exactly. Datamart is a logical subset of a datawarehouse.

Yes, there can be just one datamart in a database (data warehouse),
but that's rarely the case.

Datamarts are essentially seperate business processes.
So accounts could be one.
Sales another.
Maybe one on the telephony system analysing the calls.

All add up to a datawarehouse & all use conformed dimensions & facts.

And a planning datamart for budgeting/forecasting could have no
transactional source system as all values come from the end-users.

Read Kimball!


jbeteta (AT) yahoo (DOT) com (Jorge_Beteta) wrote in message news:<5140b91e.0310141301.5c0920ac (AT) posting (DOT) google.com>...