dimension and fact tables

Posted on 2009-04-18
Last Modified: 2013-11-10

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.

BankID    BankName    City    State    Country

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

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.
Question by:mmonline
    LVL 26

    Accepted Solution

    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.

    Author Comment


    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..
    LVL 26

    Assisted Solution

    by:Chris Luttrell
    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 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

    Author Comment


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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now