Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• 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

  9 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

  9 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

  10 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

  1 year 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

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

  1 year, 3 months 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

  1 year, 3 months 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

  1 year, 4 months 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

  1 year, 4 months 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

  1 year, 5 months 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

  1 year, 5 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

  1 year, 5 months 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

  1 year, 5 months ago

  By: Eirikur Eiriksson

• Polling Datawarehouse Design

  Hello I really need your help.I am currently working on a BI project for a polling institute.We hav…

  Lidou123

  4 replies

  1 year, 7 months ago

  By: Luis Cazares

• Build dimension as a VIEW

  Hello,I have build a dimension as a VIEW. Definition of the view is below:CREATE VIEW dbo.PowerBI_D…

  lukaszpiech

  7 replies

  1 year, 7 months ago

  By: lukaszpiech