Problem Configuring Multiple Date Relationships in SSAS Multidimensional
I’m currently working on a multidimensional cube in SQL Server Analysis Services (SSAS) with SQL Server Data Tools (SSDT). My data model includes a fact table called FACT_TICKET containing several date columns (DATE_CREATE_KEY, DATE_NEW_KEY, DATE_PLANNED_KEY, DATE_INCOURSE_KEY, DATE_RESOLVED_KEY) and a single date dimension (DIM_DATE). I configured each date column in the fact table as a separate dimension, which is not ideal and makes analysis more complex. My goal is to correctly configure the relationships between each date column of FACT_TICKET and DIM_DATE
Incremental loading Data – Data Warehousing
Today I had a technical interview for a Data Engineer position and they asked me on what is an incremental loading (in SQL por example) and how to do it, with some examples.
How to creat metadata and file index
I created cube in SSAS and I need to make a website to build an online reportenter image description here
Periodic Snapshot table design
Everyone I was going through a blog and came across the concept of periodic snapshot table.
Indexes on a SQL Server fact table
If I have a SQL Server fact table with four dimensions (OrderDate, Customer, Product, Region), my understanding is that it’s best to create a non-clustered index per foreign key (dim key column in the fact table).