Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• Data Warehousing Career Outlook & Questions for newbie

  Hey All, I wasn't sure where to post this question, so I hope it is okay here. Anyway, I'm currentl…

  pozzolan

  1 replies

  1 week, 1 day ago

  By: pozzolan

• Fact Table Update (Design)

  Hi, Apologies to Jeff & Admin (and everyone this may help) as I took down the original question…

  Niggles

  21 replies

  1 month ago

  By: Niggles

• Multiple sources for dimensions in Data Warehouse

  I am currently working on a financial Risk data warehouse. For my collateral dimension, I am sourin…

  eseosaoregie

  2 replies

  6 months ago

  By: eseosaoregie

• Fact table needs to reference two bridge tables (but same key is in both tables)

  How do I link my fact table to two different bridge tables when the same key exists in BOTH bridge …

  imb

  2 replies

  6 months, 2 weeks ago

  By: below86

• flatfiles without candidate keys to be used as unique key

  We receive data as flatfiles from branch areas containing guidelines, policy/procedures. We notice …

  zysirhc

  3 replies

  6 months, 4 weeks ago

  By: MMartin1

• Choosing which dimension tables to create

  I have an Account dimension table which contains all the accout numbers.  I also have an AccountTy…

  David McKinney

  6 replies

  6 months, 4 weeks ago

  By: MMartin1

• Best way to design and apply metadata

  I read some info regarding metadata for data warehouse that defined as data about data (got a littl…

  zysirhc

  3 replies

  9 months, 2 weeks ago

  By: higapi

• Factless fact to resolve business requirements or other design approach?

  Our client would like to have the list of candidates/employees with their corresponding position, j…

  zysirhc

  4 replies

  10 months, 2 weeks ago

  By: JacobW

• Fact Table Design

  What is the consensus on storing individual components of a measure in the fact table versus just t…

  CGSJohnson

  2 replies

  10 months, 3 weeks ago

  By: CGSJohnson

• Best Way to Provide Customer Access to Their Data Warehouse data

  Hello, One of our customers requested access to their data in Data Warehouse, what is the best way …

  hope

  2 replies

  11 months, 3 weeks ago

  By: zysirhc

• Looking for suggestions on improving our "data warehouse" approach

  I've come to find myself inheriting a loose "data warehouse" approach of sorts.  I'm quite new to …

  tarr94

  3 replies

  1 year ago

  By: tarr94

• Filtering Customer Specific Data

  Hi all! Your help would be appreciated. We have a data warehouse that is a single tenant design wi…

  tfeuz

  2 replies

  1 year, 4 months ago

  By: DesNorton

• Best way to learn Data Warehousing Concepts?

  Hello everyone. I am in need of some advice on how to learn the concepts of data warehousing. My ba…

  SilhouetteBS

  7 replies

  1 year, 7 months ago

  By: Rachel R. Fields

• Need help resisting falling back to dimensional/snowflake schemas

  In a structure for an International business with a SalesOrder and SalesOrderLine, a data model nee…

  Andrew P

  5 replies

  1 year, 8 months ago

  By: Andrew P

• Loading ODS strategies

  Hi everyone, Just curious on others' approaches on this.  So I'm developing a data warehouse in pi…

  stricknyn

  1 replies

  1 year, 9 months ago

  By: Mr. Brian Gale