Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Kimbal Fact Table Type - Transactional Fact Type Issue

3 posters

Go down

Kimbal Fact Table Type - Transactional Fact Type Issue    Empty Kimbal Fact Table Type - Transactional Fact Type Issue

Post  pedroP Fri Apr 27, 2012 6:26 am

Dear friends,
Today I post an issue related with Kimball Fact Table Types...
The following cases are two examples of Fact Tables in a dimensional model.

CASE 01
Date Customer TransactionID Sales Ammount
20120101 CLI01 FAC0005 800 €
20120101 CLI01 FAC0006 100 €
20120101 CLI02 FAC0007 500 €
20120102 CLI01 FAC0008 340 €
20120102 CLI02 FAC0009 560 €

CASE 02
Date Customer TransactionID ProductID Quantity Sales Ammount
20120101 CLI01 FAC0005 PROD01 3 300 €
20120101 CLI01 FAC0005 PROD02 2 500 €
20120101 CLI01 FAC0006 PROD01 1 100 €
20120101 CLI02 FAC0007 PROD01 5 500 €
20120102 CLI01 FAC0008 PROD01 4 340 €
20120102 CLI02 FAC0009 PROD01 6 560 €

With more or less atributes we all know that the CASE 02 is a transactional fact table. (even without line itemID)

Now, the question is: Which type of fact table you have if I decide to have the fact table CASE 01 just with dimensions Date, Customer and the Degenerate Dimension TransactionID? (Because I could not want to include the line items data.... I know I dont have the product dimension and other usefull information, but I'll have less amount of records...)

Regards,
Pedro


pedroP

Posts : 2
Join date : 2012-04-27

Back to top Go down

Kimbal Fact Table Type - Transactional Fact Type Issue    Empty Re: Kimbal Fact Table Type - Transactional Fact Type Issue

Post  ngalemmo Fri Apr 27, 2012 10:45 am

It would be an aggregate fact table.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Kimbal Fact Table Type - Transactional Fact Type Issue    Empty Re: Kimbal Fact Table Type - Transactional Fact Type Issue

Post  pedroP Fri Apr 27, 2012 11:07 am

Thank you!
It was what I thought but the confusion is that has the transaction grain...
Regards,
Pedro

pedroP

Posts : 2
Join date : 2012-04-27

Back to top Go down

Kimbal Fact Table Type - Transactional Fact Type Issue    Empty Re: Kimbal Fact Table Type - Transactional Fact Type Issue

Post  mehdigarakani Mon May 07, 2012 2:00 am

Hello,
It's got aggregated one level from item line to transaction. You should not be confused with "transaction" label. It is still an aggregated fact table.

Regards,
Mehdi

mehdigarakani

Posts : 2
Join date : 2012-05-06

Back to top Go down

Kimbal Fact Table Type - Transactional Fact Type Issue    Empty Re: Kimbal Fact Table Type - Transactional Fact Type Issue

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum