Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• 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

  5 replies

  8 hours, 24 minutes ago

  By: TheComedian

• 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

  4 days, 17 hours 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 week, 6 days 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 …

  danf80

  2 replies

  3 weeks, 2 days 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 month 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

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

  2 months, 3 weeks ago

  By: lukaszpiech

• Natural keys with data type mismatch

  Hi All, I have incoming data from 2 source systems which have datatypes of int or uniqueidentifier …

  aaa121

  1 replies

  3 months ago

  By: Brian Carlson

• Using Hash values as Dimension Keys in Datawarehouse

  All  We are exploring the idea of using a hash value as the surrogate key in Dimensions. Eg , …

  koustav_1982

  14 replies

  4 months ago

  By: xsevensinzx

• tracking the absence of an event

  im tracking attendance of courses. There is a user dimension, course dimension and a fact table. I …

  winston Smith

  4 replies

  4 months, 1 week ago

  By: winston Smith

• Pattern to load incremental data – MERGE or TRUNCATE and INSERT

  Hi,There mainly 2 patterns for incrementally loading data for facts.1. Load new records to staging2…

  leehbi

  4 replies

  5 months, 1 week ago

  By: Jeff Moden

• Healthcare Data Warehouse – Starting new – small scale

  Are there any members here in Healthcare? I work a lot with files that we get monthly from insuranc…

  usererror

  11 replies

  7 months, 3 weeks ago

  By: ZZartin

• How do you Normalize a 300 million record with 300 columns table? Nationwide Consumer Database

  Hello: Thanks in advance. How would you go about normalizing a  300 million record data set wi…

  dtran1127

  4 replies

  8 months ago

  By: Jonathan AC Roberts

• Data Vault Modelling Example

  Hello, I need help with any data vault model example that I can use to answer some questions. Data …

  greatman_g5

  1 replies

  10 months ago

  By: frederico_fonseca

• clustered columnstore index, foreign & primary keys

  Clustered Columnstore indexes (CCI) don’t support foreign & primary keys.What use are the…

  sean redmond

  2 replies

  10 months, 1 week ago

  By: sean redmond