Help on Account Receivable Datamart

• Neel009

  SSC-Addicted

  Points: 437

  More actions

  March 29, 2010 at 4:09 pm

  #213212

  Hi,

  I'm new to Data warehousing. I was given a task to build a datamart for Account receivables using 8 OLTP tables.

  Company

  Vendors

  Customers

  ContactJobs

  Invoice

  InvMemo

  InvPay

  Payments

  Invoice, InvMemo, InvPay and Payments contain all numeric data along with few fields for joining. It would be great if anybody give me an idea on which table could be dimension table and which table could be fact and how star schema looks like etc

  Thanks,

  Neel

• MostInterestingMan

  SSCertifiable

  Points: 6291

  More actions

  March 30, 2010 at 8:32 am

  #1142267

  The link below can get you started.

  http://msdn.microsoft.com/en-us/library/aa906003(SQL.80).aspx

  Thanks

  costa

  MCTS: BI 2008, MCITP: BI 2008
  Stay Thirsty My Friends