Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• 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

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

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

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

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

  12 months 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

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

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

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

  1 year, 5 months ago

  By: frederico_fonseca

• clustered columnstore index, foreign & primary keys

  Clustered Columnstore indexes (CCI) don't support foreign & primary keys.What use are they in a…

  sean redmond

  2 replies

  1 year, 5 months ago

  By: sean redmond

• Updating DW

  I have been looking into our SSIS packages which run on a daily, weekly basis and since I am new to…

  NewBornDBA2017

  1 replies

  1 year, 5 months ago

  By: heb1014

• SQL Server Replication Alternatives

  Are there any new alternatives to replication these days ? Ive used it a bit in the past, and alway…

  coreyjbaum

  1 replies

  1 year, 5 months ago

  By: heb1014

• One large vs several small files

  Files we receive from our vendor are growing larger at a rapid pace. One of the files has surpassed…

  kdbarrett 88655

  5 replies

  1 year, 5 months ago

  By: Jeff Moden

• Flexible file loading

  A big part of the data warehouse I'm currently working on is loading files from various vendors. On…

  kdbarrett 88655

  4 replies

  1 year, 7 months ago

  By: kdbarrett 88655

• Leveraging MERGE for type 2 SCD; logic for most current record

  I am a new data warehouse developer and trying to leverage the MERGE statement to manage type 2 SCD…

  vega805

  3 replies

  1 year, 7 months ago

  By: MMartin1