Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On


Strategies and Ideas Expand / Collapse
TitleStarted ByRepliesViewsLast Post
Hot Topic (New Replies)
Building ProductDim from normalized tables.  
ps_vbdev 12 223 Today @ 12:27 PM
Last Post By: RonKyle
Topic (New Replies)
Data Warehouse Design Question  

thomashohner 5 141 2 days ago @ 8:00 AM
Last Post By: RonKyle
Topic (New Replies)
Figuring out Financial Package (Agresso) Schema  

winston Smith 6 2,077 Saturday, August 13, 2016 8:56 AM
Last Post By: kjetilw68
Topic (New Replies)
How to connect multinational data warehouses?  

neophilius 3 138 Tuesday, August 2, 2016 6:52 AM
Last Post By: Spiff
Topic (New Replies)
Using Change Data Capture (CDC) for Extracting Changed Data on Multiple Tables in a Single Query  
What is the best way to query for changes when using CDC when your destination dimension table consists of multiple source OLTP tables?

Marc Beacom 4 3,205 Friday, July 29, 2016 9:20 AM
Last Post By: R.P.Rozema
Hot Topic (New Replies)
Query Question for New Guy  
Chiefsfan1976 13 411 Thursday, July 14, 2016 10:33 AM
Last Post By: j-1064772
Topic (New Replies)
What if you get org tree information when the data are already in your database?  

neophilius 0 53 Tuesday, July 12, 2016 7:41 AM
Last Post By: neophilius
Hot Topic (New Replies)
Unstructured data sources into a structured DW  
leehbi 21 541 Friday, July 8, 2016 4:54 PM
Last Post By: xsevensinzx
Topic (New Replies)
How to reorganize flatfile data in a database?  

neophilius 1 89 Friday, July 8, 2016 9:24 AM
Last Post By: Manic Star
Topic (New Replies)
Designing a >12 billion row fact table  

DJ Paulo 1 166 Thursday, June 30, 2016 8:09 AM
Last Post By: Thomas LeBlanc
Topic (New Replies)
Methods to find Surrogate Keys when creating Fact Tables  

russds 3 274 Monday, May 9, 2016 11:21 PM
Last Post By: Henning Rathjen
Topic (New Replies)
Management of the DW over 3 years with changing business requirements  

leehbi 4 201 Monday, May 9, 2016 7:14 AM
Last Post By: Henning Rathjen
Topic (New Replies)
Effective date updation in Fact records  

koustav_1982 3 197 Wednesday, April 27, 2016 12:21 PM
Last Post By: koustav_1982
Topic (New Replies)
KPIs and Soft Rules - ETL, Views or Cube?  

Paul Hernández 2 174 Tuesday, April 19, 2016 7:06 AM
Last Post By: Paul Hernández
Topic (New Replies)
Many to Many Relationship - Healthcare Diagnosis  

RRIOS42 1 153 Monday, April 18, 2016 10:50 AM
Last Post By: Lowell


Permissions Expand / Collapse

Topic Key Expand / Collapse
Topic (New Replies)  Topic (New Replies)
Topic (No New Replies)  Topic (No New Replies)
Hot Topic (New Replies)  Hot Topic (New Replies)
Hot Topic (No New Replies)  Hot Topic (No New Replies)
Poll (New Replies)  Poll (New Replies)
Poll (No New Replies)  Poll (No New Replies)
Closed Topic  Closed Topic
Moved Topic  Moved Topic