No announcements
-
1 VotesAdventureWorks OLTP to OLAP
Hi, Is there any literature about how AdventureWorksDW OLAP Dimensional database design is done based in its counterpart AdventureWorks OLTP ER ...Unanswered | 4 Replies | 267 Views | Created by etl2016 - Saturday, November 04, 2017 10:23 PM | Last reply by Thomas L. LeBlanc (MVP) - Thursday, December 07, 2017 8:14 PM
-
0 Votes
sql server report builder - Adding "Data table(chart legend)" to the Chart
Hello I have created a chart report on SQL server report builder. as you know, we can add the "data table" to chart in excel(chart ...Unanswered | 1 Replies | 137 Views | Created by Ozgur Sahin - Tuesday, November 14, 2017 1:29 PM | Last reply by Thomas L. LeBlanc (MVP) - Thursday, December 07, 2017 8:12 PM -
0 Votes
Relationship Dimension Person and Dimension Geography
Good Morning, I appreciate who can help me with this dilemma in designing a dimension for our data warehouse. We are ...Unanswered | 4 Replies | 333 Views | Created by YohaRozo - Monday, August 14, 2017 3:03 PM | Last reply by Thomas L. LeBlanc (MVP) - Thursday, December 07, 2017 8:10 PM -
0 Votes
DW Design
I am looking to build a dw from 2 operational stores. Both are accounting sources. One is sql server incremental transaction log which is applied to local ...Unanswered | 2 Replies | 183 Views | Created by rgelfand - Monday, October 30, 2017 10:41 PM | Last reply by Thomas L. LeBlanc (MVP) - Thursday, December 07, 2017 8:07 PM -
0 Votes
Turning Stored Procedure objects with Complex Business Rules into FACT and Dimensions
Most of the time measures for Fact tables are based on columns from staging tables but what if there is a stored procedure P which computes some complex business logic in it which requires joins with ...Unanswered | 1 Replies | 84 Views | Created by Haroon Ashraf - Tuesday, November 21, 2017 3:45 PM | Last reply by Thomas L. LeBlanc (MVP) - Thursday, December 07, 2017 8:06 PM -
0 Votes
SCSM QUERIES
HI I AM WORKING ON SCSM REPORTS IN TABLEAU I HAVE SOME ISSUE IN SCSM DATA BASE ,I AM USING DWDATAMART DATABASE IN THAT MY ... -
1 Votes
Escaping string_delimiter in dwloader
Let's say that I'm trying to import data using dwloader into SQL Server, and I have full control over how to format the csv input file. For the sake of discussion, I have the following table ...Proposed | 3 Replies | 758 Views | Created by Paul Zaczkiewicz - Monday, August 08, 2016 9:19 PM | Last reply by VSTODev - Tuesday, November 28, 2017 10:24 PM -
0 Votes
Report building
The purpose of this is to build a reporting ...Unanswered | 2 Replies | 226 Views | Created by CAW111414 - Friday, September 29, 2017 3:56 AM | Last reply by Tony74_19 - Monday, November 27, 2017 6:17 PM -
1 Votes
How to Join Date Dim to two Fact Tables Having Different Granularity
Team, I Have a requirement to join the Date Dim to Two Fact Tables (F1 & F2) Date Dim - Daily F1 - Daily F2 - ...Unanswered | 2 Replies | 103 Views | Created by Kiran Kandavalli - Wednesday, November 15, 2017 5:31 PM | Last reply by RichardLees - Tuesday, November 21, 2017 5:48 AM -
0 Votes
SQL Query in PDW after create linked server between PDW & SQL Server
Hi All, I have a requirement like need to develop a SSRS report that uses SQL Server PDW and SQL Server 2012 as my input sources. For this created Linked ... -
0 Votes
Archiving large tables with file groups
Good day Forum, I have a scenario where i need to archive 16 very huge tables ~700k records used for datawarehousing these tables have mostly old data from the past 7years. ...Unanswered | 10 Replies | 178 Views | Created by MSSQLBIDWH - Tuesday, November 07, 2017 2:39 PM | Last reply by MSSQLBIDWH - Wednesday, November 08, 2017 12:09 AM -
1 Votes
Measure that only applies to a portion of facttable - split facttable or add measure anyway?
Hi, I have a facttable which needs some additional metrics however these metrics will only apply to a fraction of the table. What is the best practice here? ...Proposed | 3 Replies | 257 Views | Created by JLJ1976 - Monday, November 06, 2017 4:45 PM | Last reply by RichardLees - Monday, November 06, 2017 11:46 PM -
0 Votes
Incremental load for Dimension tables
Hi, I have 14 dimension tables and there are 14 files which are built on these tables. lets say I have Table A, Table B, Table C Join to form File ...Unanswered | 4 Replies | 176 Views | Created by Pa1msd - Tuesday, October 24, 2017 8:43 PM | Last reply by RichardLees - Friday, November 03, 2017 4:15 AM -
2 Votes
Dimension model help
Hi All, This question is related to Dimensional Modelling on how can we store info about Bank ATM Card Transactions. This task is like a POC (proof of concept). ...Unanswered | 3 Replies | 168 Views | Created by Samantha v - Thursday, November 02, 2017 4:17 AM | Last reply by Visakh16 - Thursday, November 02, 2017 8:45 AM -
0 Votes
About 70-767 exam
Hi, I need to study to pass the 70-767 exam, "Implementing a SQL Data Warehouse (beta). So, I'm searching for a good practice exam. Any ... -
0 Votes
Which is better - On-Premise or Cloud for a DW Solution?
Hi, one of my clients is considering On-Premise vs Cloud Solution for having a DW / BI Solution. Option 1, On-Premise: ETL with SSIS, DW on SQL 2016 and then SSAS ...Unanswered | 2 Replies | 181 Views | Created by S.Karthick - Friday, October 27, 2017 9:01 AM | Last reply by Tom Phillips - Friday, October 27, 2017 1:49 PM -
0 Votes
My problem is about CDC
Hi to all Recently , I created CDC step by step for test from this ...Answered | 3 Replies | 193 Views | Created by Y_mrs - Sunday, October 22, 2017 5:39 AM | Last reply by Visakh16 - Monday, October 23, 2017 8:04 AM -
1 Votes
Azure SQL Data Warehouse TEMPDB running out of space
Query plan. i observed that every SELECT query - is internally taking into temp table. I need to know how TEMPDB is monitoring by Azure SQL DWH.. or is there way to Shrink ...Proposed | 1 Replies | 277 Views | Created by Sriram_DWH - Thursday, October 12, 2017 10:56 AM | Last reply by Pirlo Zhang - Monday, October 16, 2017 6:17 AM -
0 Votes
sql server memory issue
I have a csv file. Size of that file is 11gb it has 512 columns. After loading file in sql server table size is 76Gb. Table does not have any index. I dont understand why it is occupying so much ...Answered | 4 Replies | 258 Views | Created by Deepak.kumar.Chauhan - Friday, October 13, 2017 6:50 AM | Last reply by RichardLees - Monday, October 16, 2017 5:43 AM -
0 Votes
fact design for 'goal vs actual' graph
hello, I have an assignment to create a dimensional data model for the bar graph that shows goal vs actual per month. So, I have fact_sales with measures that ...Answered | 1 Replies | 163 Views | Created by SanFran111 - Thursday, October 12, 2017 5:47 AM | Last reply by David Adlington - Thursday, October 12, 2017 6:53 AM - Items 1 to 20 of 1950 Next ›
No announcements
