Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• 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

  3 replies

  2 days, 6 hours 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

  6 days, 10 hours 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

  1 week ago

  By: MVDBA (Mike Vessey)

• 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

  9 replies

  1 week, 3 days ago

  By: nova

• 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

  1 month, 1 week 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

  3 months, 2 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

  4 months ago

  By: Jeff Moden

• SSAS ROLAP to work to query low level data for large data sets with MDX?

  Sorry, this is strange, this is the third post, my posts are not visible. Let's give it another try…

  svenflock

  10 replies

  6 months, 1 week ago

  By: svenflock

• Best approach to model Tenure Groups

  Hello, What would be the best approach to model an Employee's Tenure group ? We have a fact table f…

  KevSSC

  4 replies

  6 months, 2 weeks ago

  By: KevSSC

• FACT TABLE with multiple text columns

  The fact table as of now 100 + string fields. These are mostly fields like reference numbers. For e…

  koustav_1982

  1 replies

  7 months, 2 weeks ago

  By: Paul Hough

• Incrementally loading a very large Dimension table - Performance problems

  Scenario:  I have a very large type-1 dimension table (50+ million rows and 15+ GB with page compr…

  TheComedian

  8 replies

  7 months, 2 weeks ago

  By: koustav_1982

• Data flow mapping - ETL

  Hi, I was wondering what do you guys use to map the data flow in ETL. I am looking at the field lev…

  chess-288252

  5 replies

  7 months, 3 weeks ago

  By: Nexana

• Source data security

  Hi Everyone i was asked to build a data warehouse which uses SSIS to ETL data from 5-6 data sources…

  hurricaneDBA

  2 replies

  8 months ago

  By: hurricaneDBA

• Advise on how to dimension model this senario

  I'm fairly new to dimension modelling and looking for some advise on the approach to take in modell…

  danf80

  2 replies

  8 months, 2 weeks ago

  By: danf80

• Modelling multi language datawarehouse

  HelloI need your help.I work for a survey company and I am responsible for creating its architectur…

  Lidou123

  3 replies

  8 months, 3 weeks ago

  By: Eirikur Eiriksson