No announcements
-
0 VotesBest way to deal with recording events and non events fact table
Hello, I am trying to think of the best way to deal with the following. I am attempting to design a fact table that looks at a daily feed from a Safety system and records if there ...Answered | 2 Replies | 254 Views | Created by petrodba - Thursday, September 19, 2019 7:41 AM | Last reply by petrodba - Thursday, October 3, 2019 10:34 AM
-
0 Votes
Detailed and agregated mesures in the same fact table
Hi, I have the following structure and need to manage it to have a good datawarehouse: In the database i have a table for cars and a ... -
0 Votes
Delete duplicate records from Azure SQL DW- Doesn't work
1 throws errorthat "delete statement cannot follow cte" 2)Delete statement using sub queries Delete <TableAlias> ...Unanswered | 12 Replies | 2785 Views | Created by Karthikeyan Shanthakumar - Friday, December 29, 2017 6:41 PM | Last reply by Tom Phillips - Monday, September 30, 2019 3:18 PM -
0 Votes
Fetch data in staging database if any of the dependent table data modified
Hi, After Data warehouse completed successfully, I want to delete data from the staging ...Unanswered | 4 Replies | 461 Views | Created by PriPatel - Tuesday, September 3, 2019 2:36 PM | Last reply by nkumar230 - Thursday, September 26, 2019 3:52 PM -
0 Votes
Bridge tables VS Star Schema Data Model
As known, the bridge table is a powerful way to handle dimensions that take on multiple values when associated with the grain of a fact table’s measurement event. In a simple way, a ...Unanswered | 2 Replies | 221 Views | Created by Test test tes - Friday, September 20, 2019 12:24 PM | Last reply by Test test tes - Friday, September 20, 2019 2:14 PM -
2 Votes
Many to Many relationship between two Dimensions and Fact
I have a request for an attribute in a dimension that has a many-to-many relationship with another dimension. Here is the ...Answered | 3 Replies | 469 Views | Created by Test test tes - Thursday, September 19, 2019 11:30 AM | Last reply by nkumar230 - Thursday, September 19, 2019 4:42 PM -
0 Votes
MDX Query to calculate Average rather than Sum and hide it
Looking to calculate the Avg instead of sum but do not want to display itUnanswered | 2 Replies | 304 Views | Created by bluejay2013 - Friday, September 13, 2019 3:55 PM | Last reply by nkumar230 - Wednesday, September 18, 2019 3:05 AM -
0 Votes
How to perform incremental load in staging database
Hi, How to perform incremental load in staging database to fetch newly and updated data. Thanks,Unanswered | 12 Replies | 595 Views | Created by PriPatel - Wednesday, September 4, 2019 2:47 PM | Last reply by Guoxiong - Thursday, September 12, 2019 2:06 PM -
0 Votes
KImbell
I am really confused here . Are the datamarts used in Kimbell's approch are in 3NF form or dimensional modelling form. In kimbell data are extracted from sources and loaded in ...Proposed | 4 Replies | 455 Views | Created by neha bhatt1 - Thursday, August 29, 2019 4:20 PM | Last reply by nkumar230 - Thursday, September 12, 2019 4:35 AM -
0 Votes
Dimension attribute with one-to-many relationship
I have a request for an attribute in a dimension that has a one-to-many relationship with the lower level of the dimension. Here is the case: Dimension: Employee ...Answered | 2 Replies | 458 Views | Created by Test test tes - Wednesday, August 21, 2019 11:51 AM | Last reply by nkumar230 - Thursday, September 12, 2019 4:34 AM -
0 Votes
how to change 12 hour date format to 24 hour date format in Sql server
Hi , could anybody explain me how to change 12 hour time format to 24 hour time format in SQL server and after that i want to get the difference between those two date fields in ...Unanswered | 4 Replies | 259 Views | Created by ds_999 - Wednesday, September 11, 2019 6:37 AM | Last reply by Olaf Helper - Wednesday, September 11, 2019 10:55 AM -
0 Votes
Issue faced when performing incremental load in parent child relationship tables to dump data in data warehouse tables
Hi, I have Emp and EmpDetail table. Firstly my initial load package is executed and data are dump in Staging database(Source and Staging table structure is same). Then, with the ...Unanswered | 0 Replies | 247 Views | Created by Dhara Prajapati - Wednesday, September 11, 2019 5:08 AM -
0 Votes
Sql server table partitioning in Data Warehousing
Hi guys, I am trying to implement table partitioning on one of my facts that have over 200M records and i am stuck. I have created 13 ...Unanswered | 5 Replies | 381 Views | Created by Nicholas.G.M - Thursday, August 29, 2019 7:52 AM | Last reply by SaravanaC - Thursday, August 29, 2019 3:27 PM -
0 Votes
Kimball Modelling Approach- SSAS
Hi We trying to design data marts for 2 specific areas and we want to understand tabular performance for if we increase columns but ... -
0 Votes
Issues with row level security
I have setup row level security using a function and the below code: CREATE FUNCTION security.fn_securitypredicate(@TenantId AS sysname) ... -
0 Votes
Sharepoint log DB file is Huge. >300Gb
My SQL server is running out of space. the main culprit seems to be 2 database files Sharepoint_config_log 340GB of 480GB Sicon_log 125Gb of ...Unanswered | 4 Replies | 494 Views | Created by Alex10318 - Friday, August 23, 2019 10:25 AM | Last reply by Dmitri Korotkevitch - Monday, August 26, 2019 8:40 PM -
0 Votes
Some problems related to dimensional modeling in Data Warehouse.
I have asked these questions in Stack Overflow, but no one there answers me, so I bring them here, hoping someone can answer my questions. I am developing a BI system for our ... -
0 Votes
How to capture change data in the Staging Area
Hello All, Thanks in Advance i did analysis in all the level still i am not getting correct solution regarding incremental load in the staging ...Unanswered | 9 Replies | 694 Views | Created by gvrspk veni - Monday, July 29, 2019 3:17 PM | Last reply by Soumen Barua - Tuesday, August 6, 2019 6:28 AM -
0 Votes
Inserting data into SQL table from Oracle table taking huge time for 6 millions records
'' set @FromClause = Concat(' FROM Openquery(' , @LinkedServer , ', ''Select * FROM "' , @OracleSchema , '"."' , @TableName , ...Unanswered | 3 Replies | 542 Views | Created by Visu1986 - Friday, August 2, 2019 9:55 AM | Last reply by Soumen Barua - Monday, August 5, 2019 3:36 AM -
0 Votes
Load data into different target tables having different columns from different source tables through Dynamic SQL
Hi, I am trying to create a stored procedure which will load data into different target dimension tables having different columns from different source tables using dynamic sql. ...Unanswered | 1 Replies | 602 Views | Created by Visu1986 - Saturday, July 27, 2019 6:06 PM | Last reply by Visu1986 - Friday, August 2, 2019 9:36 AM - Items 1 to 20 of 2136 Next ›
No announcements
