Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• how to split data in ssis

  Hi Friends , source data comes like id , name , sal …

  asranantha

  2 replies

  14 years ago

  By: steveb.

• Derive a dimension from source with no business key

  Hello, I need to create a status dimension. In the source system each job has a status which is a t…

  aaa121

  2 replies

  14 years ago

  By: wildh

• how to load 100 flat files source in ssis

  Hi friends, i have 100 flat files .flat file souce different format that means …

  asranantha

  2 replies

  14 years ago

  By: wildh

• Adding new SCD 2 attribute to existing Dimension AND history required

  I've just had a lively discussion with a dev here on the best/proper way to approach adding a new S…

  nahk.fussuy

  6 replies

  14 years ago

  By: RonKyle

• Basic question: Dimension tables - how do you handle changes (i.e. store's manager or floor plan type)?

  I'm reading Kimball's: The Data Warehouse Toolkit The Complete Guide to Dimensional Modeling (2nd e…

  Maxer

  4 replies

  14 years ago

  By: RonKyle

• Suggestions for data warehouse design 101: books, videos, etc...?

  So our company is going to start building a data warehouse. We are looking at hiring an outside con…

  Maxer

  4 replies

  14 years ago

  By: Maxer

• Incremental load - using timestamp reliable?

  We have a transactional database with every table containing create_date and update_date columns. W…

  Shurkadze

  13 replies

  14 years ago

  By: PaulB-TheOneAndOnly

• Storing XML in a Data Warehouse

  Hi - we're starting to require a bit more flexibility from our Data Warehouse to return more inform…

  SinisterPenguin

  3 replies

  14 years, 1 month ago

  By: PaulB-TheOneAndOnly

• Optimal SSD drive configuration for DW server? Beneficial to keep ODS and DW in separate logical drives?

  hi all, I am planning to upgrade / reconfigure my BI / DW servers, and I want to vet it with all th…

  boxta

  2 replies

  14 years, 1 month ago

  By: PaulB-TheOneAndOnly

• Mapping data from separate systems

  I am in the process of designing a DW (something I have no prior experience of), part of which will…

  ian.scrivens

  1 replies

  14 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Dimension Design Question

  What I have is less of an actual technical issue and more of a design question...a fairly "simple" …

  Anthony Robinson

  2 replies

  14 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Time Varing Numerical Quantity

  Hi All, I have a quick question, I appreciate any quick response. Thanks in advance.

  sqlTechie

  9 replies

  14 years, 2 months ago

  By: sqlvogel

• Real Business Situation

  Hi All, I have a quick question, Kindly give an example of a real business situation where neither …

  sqlTechie

  1 replies

  14 years, 2 months ago

  By: spaghettidba

• Related data within the same facts

  How do you store facts within which data is related? And how do you configure the measure? For exam…

  MR-216760

  3 replies

  14 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Inserting Data in the Middle of a Partition

  I am designing the load a Data Warehouse from a Data Mart. The existing data mart is partitioned by…

  michael.french 172

  4 replies

  14 years, 2 months ago

  By: stevefromOZ