• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

dimension and fact tables

hI,

I am creating a data warehouse for the following two tables:



Table1 :

Bank Name / Holding Co Name              Natl Rank      Bank ID Bank Location   Charter Consol Assets (Mil $)   Domestic Assets (Mil $)     Pct Domestic Assets    Pct Cumulative Assets  Domestic Branches    Foreign Branches  IBF    Pct Foreign Owned          

JPMORGAN CHASE BK NA/JPMORGAN CHASE & CO     1     852218     COLUMBUS, OH     NAT     1,768,657         1,181,802             67             16             3,554         45         Y     0.00

BANK OF AMER NA/BANK OF AMER CORP             2     480228     CHARLOTTE, NC     NAT     1,359,071         1,251,657             92             28             5,775         35         Y     0.00


Table 2:
Date     Current Assets    Current Liabilities    Long Term Debt    Shares Outstanding      Bank Name
12/08    1,817,943.0    1,640,891.0        299,001.0    5.0 Bil  Bankof America



and I came up with this solution.


DimBankDetails
BankID    BankName    City    State    Country

FactAccount
BankID    Date  [Consolidated Assests]   [Domestic Assests]  [Current Assests]  [Current liability]  [Long Term Debt]

FactBranches
BankID    Date    Rank    Charter    IBF    Domestic Branches    Foreign Branches


can i use two fact tables and one dimension table in a data warehouse.

Please tell me if I am correct. I am actually new to datawarehouse.
0
mmonline
Asked:
mmonline
  • 2
  • 2
2 Solutions
 
Chris LuttrellSenior Database ArchitectCommented:
Short answer is YES you can use the same dimension table accross two or more fact tables.  It is called Conforming Dimensions in datawarehouse parlance.
0
 
mmonlineAuthor Commented:
Hi,

Thank you and please tell me if my tables are correct for the input data..

I mean do I need to add any other columns or dimension tables..
0
 
Chris LuttrellSenior Database ArchitectCommented:
Thats a broad question, sort of like "Tell me everything I don't know!"
Your FactAccount table looks ok for what is has in it but I am not sure what your are planning for FactBranches, looks almost like attributes for the dimBank instead of another Fact table.  Other dimensions would usually include a dimDate to set the granularity of the Fact table.  I suggest you look at http://www.kimballgroup.com/ and the huge list of Design Tips and Articles & Papers there.  I also recommend Kimball's books, I use almost all of them (haven't got into the Webhouse yet).  Another good link for starting to think about DW at http://www.dbmsmag.com/9708d15.html.
0
 
mmonlineAuthor Commented:
Hi,

Thats okay.. I am not having much time now..anyway I will go through them..
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now