relating 2 existing dimensions combined to a fact table
given: * 1 existing sales fact table; > 1.500.000.000 records * 1 existing product dimension; >= 300.000 records * 1 existing store dimensions; >= 1.000 records required: * 3 new attributes, defined by the combination of a certain store an

Same attribute in multiple dimensions or Create new dimension?
Hi all - I'm struggling with this concept. I have 2 dimensions: Customer and Products. Both share a common single attribute that I'll just call "Owner" for now. If a customer purchased a product, the owner would be the same for both. I

Conforming Dimensions - Standardising, De-duplicating and Suvivorship
Hi, I'm currently reading the DW ETL toolkit, which seems to have some excellent ideas. However, as it doesn't come with any downloads (e.g example SSIS packages) - I'm struggling to understand a few things. If anyone can answer the following it would

Database Partitioning and Dimensions without the distribution key
We are upgrading our data warehouse platform, and now have the option to partition the database across CPUs as well as partitioning tables themselves. For database partitioning, there is a performance impact if the data from tables to be joined is not

A fact table surrounded by a lot of references tables
I am reviewing a design which is about to be implemented after build. There is a fact table with 17(!!) foreign keys. 14 of these keys are two-letter codes pointing to reference-tables (as we call them). A reference table consist of codes with

How to manage Conformed dimensions
Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this

Best Praticte for inserting fact and linking to dimensions
Hi all, is it allowed to have null values in fact table for some dimensions foreign keys ? Exemple : DateDimFk DimFk1 DimFk2 50 (coming from business system 1) DateDimFk null DimFk2 50 (coming from business system 2) or do i have to create a

"Shared Dimensions" ... Complicates Usage of Data Warehouse??
Question about 'Shared' dimensions. I have the following shared dimensions: Dim_Shared_Status & Dim_Shared_StatusType Dim_Shared_Status contains: [Id], [StatusTypeId], [Name] Dim_Shared_StatusType contains: [Id], [Name] Now

Data Marts, Conformed dimensions and Data Warehouse
Hello, Can you please assist me in understanding the following. I am new to data warehouse. I'm using microsoft products to build my enterprise DW/BI 1. Do I build data marts for my enterprise DW/BI or do I iteratively build a data warehouse? I

Snapshot Dimension & Fact tables
We are currently designing a logical multidimensional model from an OLTP tables.Dimension tables have monthly snapshot because some of or all the attributes might change on monthly basis.The same situation for the fact table has monthly snapshot. I kno

Junk Dimension Naming
What do you call your junk dimensions? Do you use "junk" in the dimension name? Junk implies garbage so I don't like using it. Most dimensions are easily named since they represent a single person, place, thing, concept, or event. Junk

Playing with fire, best built char hybrid for cabal
juswanted to seewhich is thebest built for any char, now i aint saying sshit like sword wa and magic wi. alone, imean everything on everything

What kind of roleplay do you do?
Do you have experience in roleplay? If so, what kind? And if not, then what do you want to do? Personally, I never went for any of that realistic stuff. I got boring. My friend and I picked a few characters from fandoms and just played with silly,

Murex - Technical Team Leader role – Wholesale Bank in Singapore
Responsibilities: The role is to lead a team of technical experts to manage and support Wholesale Bank’s Financial Markets derivatives trading platform. Permanent Position based in Singapore. Skills - Essential * Knowledge of technical

Degenerate Dimensions
Hi there, I have come across a situation where my Fact table contains a degenerate 'Claim Number' column. This is fine, but I have discovered that some of the incoming data to populate my fact table do not have a claim number. How should I handle this