Stack Overflow
Stack Overflow

Questions tagged [sql-data-warehouse]

108 questions
0
votes
0 answers

PostgreSQL as OLAP setup

I am trying to setup postgresql to use OLAP benefits as my current OLTP db is no more required, hence i want to move it to OLAP system for genrating reports as there would not be much transactions where as onlny reporting and other warehouse…
Amit
  • 31
  • 1
0
votes
1 answer

SCD TYPE 2 Implementation

Needs to implement SCD TYPE 2 Table in SQL server. Which insert new record and update timestamp if Threshold Values changes for particular Band. If no changes found then doesn't touch the…
Gaurav Jan
  • 13
  • 2
0
votes
0 answers

How to import datawarehouse to excel without using odbc?

I want to know how to import data warehouse to excel and load fast without using odbc. It's taking too long to load platform datawarehouse DATABRICKS I just tried to import the normal way via odbc, however, it's taking too long and I need to know if…
nicarcol
  • 1
0
votes
1 answer

Azure Synapse Analytics - Dedicated Pool - Create user - Incorrect syntax near 'PASSWORD'

I'm trying to create a Contained Users in Synapse Dedicated Pool using the below command create user [username] with password = 'Comple@xPassword@123' default_schema = 'dbo' It's failing with the below error message Parse error at line: 3, column:…
Prawin
  • 1,158
  • 2
  • 12
  • 26
0
votes
1 answer

How to set default time zone for SQL Warehouse in Databricks?

I want to change the default time zone for SQL Warehoue in the SQL Persona, in Databricks. When I try to Edit the SQL warehouse settings in the "SQL Warehouses" section, I am not able to find any setting where I can set the time zone. I am aware…
Mohammad
  • 775
  • 1
  • 14
  • 37
0
votes
0 answers

I am using SSIS Vs to populate my fact table from staging to data warehouse but it is showing an error to the OLEDB destinations

[OLE DB Destination [77]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "OLE DB Destination.Inputs[OLE DB Destination Input]" failed because error code 0xC020907B occurred, and the error row disposition on "OLE DB…
vimbai
  • 1
  • 1
0
votes
1 answer

Invoice header and invoice line fact table extraction question

I have a question regarding the best practice regarding the loading of invoice header and line data inside InvoiceLineFact table. I am following the Kimball recommendation where I bring all the dimensionality of the header down to the line items…
stevo92
  • 11
  • 3
0
votes
0 answers

SSAS "The Subscription identifier is invalid"

We switched from a SQL server 2017 to a newer SQL server 2019. We deployed all our SSIS-packages in the same way to the newer server. Since then we have often the same error on processing-tasks like cube-processing or dimension-processing on the…
Basssprosse
  • 334
  • 1
  • 3
  • 17
0
votes
1 answer

Generate a number for a combination of columns in SQL Server

I have a requirement to generate an ID field for a combination of a few fields in SQL Server. Let me give you an example. I have a table like…
Cody
  • 21
  • 3
0
votes
0 answers

Querying a Galaxy Schema in data warehouse

I have a galaxy schema that looks like this what I want to extract from this schema is data from dim1, dim 2, fact1 and dim 4. I have written this code but I am not sure if it is correct. lets suppose that dim1 has d1 value, dim2 d2 , fact1 f1 and…
rexhi
  • 1
  • 4
0
votes
1 answer

Dimensions inside FACT table?

I am in the process of building a warehouse and I am unsure how to handle a certain element. We have a query that returns a table of "Quotes" a quote is basically when we have provided a quote to a customer for a service. Some of these quotes will…
SQL_Kid
  • 79
  • 10
0
votes
0 answers

Many-to-many from relational design to dimensional design

This is my database design: I make a data warehouse a with 2 fact table design as you show : I want to add Order dimension but the problem is that there is bridge table between product table and order table by the way order table contain 830 rows…
zouhair zouita
  • 145
  • 2
  • 2
  • 7
0
votes
2 answers

How to add a column based on the table which the data come from in SSIS?

I have two source tables: Ext_Agreements ABS_Agreements both have the same columns : "each table have different data this is just an example" ID, START_DATE, END_DATE, 01, 28/02/2021,…
Guissous Allaeddine
  • 425
  • 1
  • 4
  • 19
0
votes
1 answer

Data warehouse design for parking lot - date and time dimensions

I came across a data warehousing practice question. I tried to think of various ways to design this but I'm not sure what the best practices are. The question deals with designing a data warehouse for a parking lot and writing a SQL query for…
MJoy
  • 1,349
  • 2
  • 9
  • 23
0
votes
2 answers

Filter overlapping date ranges with latest "Valid from" date

I have a table with price lists that specifies the price of an item in a country for a specific time period. The issue with my table is, that there are overlapping price lists for the same item in the same country. What I wish, is to select the…
Rubrix
  • 191
  • 12
1 2 3
4
5 6 7 8