Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• Dynamic Cleanse Commands and Check Queries - Design Ideas

  I am looking at automating a repetitive task (using SSIS) and would be interested to know if anybod…

  HenryKrinkle

  1 replies

  6 days, 17 hours ago

  By: scdecade

• Adding a column to a Type 2 SCD

  Hello, I have a standard type 2 SCD that is performing well however the business have asked for add…

  david_h_edmonds

  1 replies

  1 week ago

  By: HenryKrinkle

• Data Lake - Data Warehouse Strategies

  Hi, Please forgive me if this is wordy.  I am working on a future strategy for our BI environments…

  TDouglass

  1 replies

  3 weeks ago

  By: TDouglass

• utilizing CDC to capture changes

  Hello, sorry I am fairly new to data warehousing, though I have some little experience and concepts…

  Siten0308

  3 replies

  3 weeks ago

  By: Sue_H

• First DW design - advice appreciated

  All, Up to this point I've only worked with relational databases. I'm trying to teach myself data w…

  as1981

  2 replies

  1 month ago

  By: as1981

• An international challenge

  Please indulge me for asking a rather vague, 10,000 foot type question. I hope to get some feedback…

  jonathan.matt

  3 replies

  1 month, 2 weeks ago

  By: jonathan.matt

• Sequence For a Dim Table's Durable Key

  I am using a sequence as the durable key (DK) of a dim table.  It gets its value from a sequence f…

  imani_technology

  1 replies

  2 months ago

  By: Chris Harshman

• Is a durable key always necessary in a dim?

  I want to use a Type 2 SCD SSIS transform on a dimension table that does not have a durable key.  …

  imani_technology

  15 replies

  2 months ago

  By: imani_technology

• Tracking History in Fact Table

  Hi, I was hoping somebody would be able to offer advice in relation to tracking history in a fact t…

  Niggles

  19 replies

  2 months ago

  By: Jeff Moden

• DW design help

  Hi Guys, I need advice. I am in the designing phase of building a DW. Question 1:- My source has (C…

  rocky_498

  1 replies

  2 months, 1 week ago

  By: Jeff Moden

• Programmatically determine intersection of flight paths and countries

  A friend of mine asked me an interesting question... Given a flight path (a linestring of sorts), c…

  pietlinden

  2 replies

  2 months, 2 weeks ago

  By: CGSJohnson

• Pre Staging Data

  Hi, I am wondering what peoples thoughts are on "Pre Staging" data in the ETL Process. I have only …

  david_h_edmonds

  9 replies

  2 months, 2 weeks ago

  By: MVDBA (Mike Vessey)

• Views vs. UDFs vs. Stored Procedures for Data Warehouse Reports

  We are working on a data warehouse with a star schema.  Our reporting tools will be SSRS and Table…

  imani_technology

  15 replies

  3 months, 3 weeks ago

  By: Grant Fritchey

• Calculations from 2 fact tables

  I have a situation where there are 2 facts tables representing SalesLeads / Sales.    These facts…

  leehbi

  2 replies

  5 months, 3 weeks ago

  By: pietlinden

• What do bridge tables contain?

  I understand that one technique for many-to-many relationship implementation in data warehouses in …

  elea.grig

  9 replies

  6 months, 1 week ago

  By: Jeff Moden