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
Topic (New Replies)
Data Warehouse Design Question  

thomashohner 5 261 Monday, August 22, 2016 8:00 AM
Last Post By: RonKyle
Topic (New Replies)
Figuring out Financial Package (Agresso) Schema  

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

neophilius 3 199 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,329 Friday, July 29, 2016 9:20 AM
Last Post By: R.P.Rozema
Hot Topic (New Replies)
Query Question for New Guy  
Chiefsfan1976 13 501 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 93 Tuesday, July 12, 2016 7:41 AM
Last Post By: neophilius
Hot Topic (New Replies)
Unstructured data sources into a structured DW  
leehbi 21 669 Friday, July 8, 2016 4:54 PM
Last Post By: xsevensinzx
Topic (New Replies)
How to reorganize flatfile data in a database?  

neophilius 1 115 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 217 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 324 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 242 Monday, May 9, 2016 7:14 AM
Last Post By: Henning Rathjen
Topic (New Replies)
Effective date updation in Fact records  

koustav_1982 3 233 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 217 Tuesday, April 19, 2016 7:06 AM
Last Post By: Paul Hernández
Topic (New Replies)
Many to Many Relationship - Healthcare Diagnosis  

RRIOS42 1 198 Monday, April 18, 2016 10:50 AM
Last Post By: Lowell
Topic (New Replies)
Using Bridge tables for 1 to Many Relationships. Primary and Foreign Key Creation  

Debbie Edwards 5 812 Monday, April 18, 2016 10:29 AM
Last Post By: RRIOS42


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