No announcements
-
Sticky0VotesNew Top Support Solutions blog
Hello As part of our efforts to keep our communities informed about the most relevant content that address the top questions that we are getting in out forums and other support ...
-
Unanswered0Votes
apply cdc to existing data warehouse
truncate staging tables prior to load, track changes between staging tables, dim tables and fact tables, to incrementally load rows to dim tables and fact tables? Do i need to add a ...1 Replies | 34 Views | Created by jhowe1 - 8 hours 35 minutes ago | Last reply by jhowe1 - 3 hours 7 minutes ago -
Unanswered0Votes
Filter dimensions by other tables
I'm attempting to convert an existing relational database to a SSAS solution. I'm new to SSAS though and would appreciate advice on how to handle the following ...2 Replies | 82 Views | Created by GraemePM - Monday, June 02, 2014 9:59 PM | Last reply by Visakh16 - 13 hours 48 minutes ago -
Proposed0Votes
Is this part of product dimension
Im building a product dimension of all the dresses designers can sell. each dress can have multiple sizes and colors a cost price and rrp price and also a size ...2 Replies | 170 Views | Created by Plip71 - Tuesday, May 27, 2014 9:25 PM | Last reply by AMeador - 22 hours 47 minutes ago -
Proposed0Votes
Record locking issues - Error handling design - MAXDOP 1 - very confused
0 ROLLBACK TRANSACTION SET @Message = ERROR_MESSAGE() SET @ErrorSeverity = ERROR_SEVERITY() SET @ErrorState = ...7 Replies | 108 Views | Created by Mark Roworth 2 - Monday, June 02, 2014 9:42 AM | Last reply by davidbaxterbrowne - Monday, June 02, 2014 3:40 PM -
Answered0Votes
Unable to mount SQL ops manager ware house database
Hi All, Please help me in this. We have SCOM 2007 r2 and its SQL data ware house database is dismounted and we are unable to mount it. I get the below error when i mount the Ware ...2 Replies | 168 Views | Created by Gautam.75801 - Sunday, May 25, 2014 6:10 PM | Last reply by Gautam.75801 - Thursday, May 29, 2014 6:17 PM -
Unanswered1Votes
Relationship between Dimension without linking Fact table
Hi, My question is like I have five dimensions connected to a fact table through primary - foreign key(Composite Key) relationship. Will this referential integrity help if I want ...2 Replies | 352 Views | Created by SanjoySanjib Ghosh - Thursday, February 06, 2014 7:36 AM | Last reply by Sunil Agarwal - Thursday, May 29, 2014 3:59 PM -
Proposed0Votes
REORG of Clustered Columnstore Index during tuple mover operation
Hi, I want to automate index REORG/REBUILD for my clustered columnstore indexes. Basically, REORG should kick in once I got closed rowgroups, and do REBUILD in ...1 Replies | 176 Views | Created by hessie - Friday, May 23, 2014 8:59 AM | Last reply by Sunil Agarwal - Thursday, May 29, 2014 1:25 AM -
Unanswered0Votes
T-SQL to Handle Fact Table which holds DimensionKeys from different dimensions
Hello, I need help in learning and developing code for Fact Tables. How to handle SCDS ? and how to put all dimensions together in a T-sql code and build ...1 Replies | 224 Views | Created by KODI_KODI - Wednesday, May 21, 2014 12:19 PM | Last reply by Mike Yin - Wednesday, May 28, 2014 2:36 AM -
Unanswered0Votes
Recommendation on using SQL 2012 MDS
Hello there, Can someone make a recommendation on how to use SQL 2012 Master Data Services in this scenario... In my source application, I have 2 tables, which ...5 Replies | 277 Views | Created by Djj66 - Wednesday, May 14, 2014 4:33 AM | Last reply by Djj66 - Monday, May 26, 2014 5:19 AM -
Proposed0Votes
OPENROWSET VS BULKCOPY
ALL, I have an bcp out file generated in native format from a table. The table has few columns which are nvarchar(max). I try to import the same into another table of same structure, but want to ...1 Replies | 156 Views | Created by kart - Thursday, May 22, 2014 3:14 PM | Last reply by davidbaxterbrowne - Thursday, May 22, 2014 3:30 PM -
Answered1Votes
SQL Data Warehouse Business Key vs. Surrogate Key
Hi all, i'm fairly new to data warehousing and i have a few questions. I'm trying to import data from a horrible highly normalised database into an Education DWH (to answer questions like grade ...6 Replies | 505 Views | Created by jhowe1 - Thursday, April 10, 2014 4:38 PM | Last reply by jhowe1 - Thursday, May 22, 2014 7:10 AM -
Unanswered0Votes
Best practise to move data to new datawarehouse partitions
Our DW is about 500GB and expected to double in the next three years. Largest table has 290m rows, but some fact tables have as little as 1k rows. We are also ...2 Replies | 573 Views | Created by markfromhouston - Monday, May 12, 2014 3:30 PM | Last reply by Sunil Agarwal - Wednesday, May 21, 2014 11:26 PM -
Unanswered0Votes
Nulls Replaced with Default Value in Warehouse
My manager wants to know why exactly I replaced null date of death in our data warehouse with a default value (1/1/1800). I explained that the BI literature was ...7 Replies | 258 Views | Created by 318Siam - Friday, May 16, 2014 9:43 PM | Last reply by 318Siam - Tuesday, May 20, 2014 4:01 PM -
Answered0Votes
SQL Server 2012's Parallel Data Warehouse (PDW) Optional Add-on?
Hi, I work for the State of Illinois and though we have progressive IT shop, we tend to be a bit behind the curve. We are still using SQL Server 2005 for all our data needs and have been ...1 Replies | 200 Views | Created by Ron_Kunce - Tuesday, May 20, 2014 1:22 PM | Last reply by Matt Usher (MSFT) - Tuesday, May 20, 2014 1:32 PM -
Unanswered0Votes
Performance data from system and DMS logs on PDW.
I want all of ther performance data as given below of the particular completed job with respective login ID from system or DMS logs on PDW What is total Memory and CPU used for ...1 Replies | 236 Views | Created by PRASAD KVSV - Monday, May 12, 2014 10:01 PM | Last reply by Leo N - Monday, May 19, 2014 2:14 AM -
Answered0Votes
Difficulty flipping from relational modeling to dimensional modeling
Im building my first star schema Order fact table with Product, retailer. date and customer dimensions so that's fine. im finding it hard getting my mind set out ...4 Replies | 277 Views | Created by Plip71 - Tuesday, May 06, 2014 3:24 PM | Last reply by Mike Yin - Friday, May 16, 2014 3:55 AM -
Unanswered0Votes
Loading data from SAS tables to SQL server database
Hi Guys I am championing a BI Proof of Concept project to create a self-service BI platform using tabular model parallel to our traditional BI platform on ... -
Answered0Votes
What Master Data to hold within a Data Warehouse
Hi, We are developing a data warehouse which will incorporate Master Data entities. We have a pre-existing Master Data Management solution which will be ...2 Replies | 287 Views | Created by Daryloreg - Sunday, May 04, 2014 2:33 PM | Last reply by Stefan Hoffmann - Tuesday, May 13, 2014 10:09 AM -
Proposed0Votes
Data modeling tool to design a dwh - SQL Server 2008 R2-2012
Hi, I need to know if it exists a Microsoft tool to model the data structures of a data warehouse. I generally use the SQL Server diagrams but I'd like to know an enhanced tool. ...2 Replies | 323 Views | Created by pscorca - Wednesday, April 16, 2014 1:45 PM | Last reply by Reza Raad - Tuesday, May 13, 2014 9:14 AM -
Answered0Votes
Reuse Dimdate across different database for different data models
Hi, I am designing a new data model for a data mart. I need to add dimdate dimension in this data model. I noticed that dimdate already exists in another database and being ...3 Replies | 247 Views | Created by Inquisitive_26 - Thursday, May 08, 2014 5:25 AM | Last reply by Reza Raad - Tuesday, May 13, 2014 9:12 AM - Items 1 to 20 of 1337 Next ›
No announcements
