I always doubted if I should include ID or the actual text in the dimensions. For example, see DimSalesPerson in the screenchot below - https%3A%2F%2Fwww.codeproject.com%2FArticles%2F652108%2FCreate-First-Data-WareHouse&psig=AOvVaw2oGn_eyUgi8KV9m_u6PSIF&ust=1666197880975000&source=images&cd=vfe&ved=0CA0QjhxqFwoTCOjG9_6c6voCFQAAAAAdAAAAABBJ. Instead of using StoreName as text in DimSalesPerson, they used StoreID. What do you usually do in the cases like that when there is an attribute in a dimensions table A that has a stand-alone dimensions table B?
Data warehouse modling - to use ID or text in a dimensional table
181 Views Asked by eponkratova At
1
There are 1 best solutions below
Related Questions in DATABASE-DESIGN
- SQL schema for a fill-in-the-blank exercise
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- steps to create a web app with backend and database and web
- Use data type uuid or varchar(36) for my UUID column?
- Containing Object Design
- Many-to-many relationship between objects of the same type
- When hashing an API key, should I hash the suffix / prefix as well?
- Database design, authentication and authorization in a microservices ticketing system
- Unique index on 3 columns where NULL conflicts with all other values in one column
- Can i create a table with 2 foreign keys? These 2 foreign keys are 2 primary keys of 2 different tables
- I have a basic ms access question about a relationship between 3 tables
- how can i calculate mutual friends/followers efficiently?
- Access Table ,setting in design ,column 'Catagory' as Combobox in lookup with list "Action";"War";"Drama". in vb.net DGV and Detail how to multiselct
- Table Design for Calculating Median Over User-Defined Period from Pre-Processed Data
- Use conditional constraint or normalize table?
Related Questions in DATA-MODELING
- Does Power BI provide an OOTB Geographical Dimension Table
- Table Restructuring Options in PowerBI
- How to model such that a drill through for Order suppliers having M:1 relation with Order fact table can be configured?
- Excel formula to change sum field depending on date
- How to properly define data models in TypeScript?
- Power Bi - Modelling
- How to create a MySQL table or store the values in the MySQL table if values is of type python list
- Dynamo DB M:N relationship issue
- What data type is appropriate for star schema keys (integer or text)?
- How to fetch data from this Nested JSON using GET method in flutter using Data Model?
- How to model composite primary keys in the ER model?
- LSTM layer in Sequential model requires 3d input but only receives d2
- How can I generate many random community matrices and then apply a function to all of them?
- Model the number of available spots in dimension or fact table?
- How to get data collection from a nested list of a data collection from postman api to list<dynamic> in dart Flutter
Related Questions in DATA-WAREHOUSE
- How to blind data in data warehouse when sending from preanonymized layer to anonymized layer while keeping referential integrity of all key columns
- Run Pyspark job using Matillion
- the right grain of a fact table in data warehouse
- Model the number of available spots in dimension or fact table?
- What is the most efficient way to generate a change data set given two SQL Server backup files?
- Does it make sense to use an IDENTITY column in a raw layer?
- Power BI star (constellation) schema: 2 fact tables with relation between each other
- Rolling Period Table or CTE
- Representation of sequential rules in data mining (sequence pattern mining)
- Snowflake Bulk Inserts vs. Single Row Inserts
- Data not showing in power bi report
- Data Warehouse to Power BI Desktop
- Error initialize process greenplum major upgrade 5.29.12 to 6.25.2 on centos 7
- Modify column type in Parquet file with ruby (using parquet Gem)
- Translating Snowflake warehouse usage to BigQuery
Related Questions in STAR-SCHEMA
- How to model such that a drill through for Order suppliers having M:1 relation with Order fact table can be configured?
- Indexed parent-child hierarchy table to fact table
- Power BI star (constellation) schema: 2 fact tables with relation between each other
- Difficulties with Data Model Design
- Should dimension tables ever be larger than fact tables?
- Dimensional Modeling: Joining Dimensions together without a Fact Table
- When do I update things via Slowly changing dimensions and when via Fact table?
- How to handle order line level dimension when used along side a Order level measure?
- How to model a header detail level granularity table alongside a header level fact table when a certain dimension is only applicable to the header?
- How to model a header detail requirement when header has values that cannot be apportioned to details?
- OLTP-STAGGING-DW-DUPLICATES
- Order of duplicate keys in non-clustered indexes [SQL Server]
- Creating a relationship between unconnected tables
- SQL DWH create new foreign logic
- Handling updates in Apache Druid for data from a commerce system
Related Questions in STAR-SCHEMA-DATAWAREHOUSE
- INSERT a single row in fact table
- How to deal with multiple facts in dimensional modelling
- PostgreSQL as OLAP setup
- PostgreSQL ON CONFLICT add new entry with new timestamp
- Bridge table for many-to-many relationship
- Stream data into BigQuery data mart with three different dataflow jobs, get correct surrogate key for the fact table from dimensional tables
- Data warehouse modling - to use ID or text in a dimensional table
- Dimension Fact tables issue
- Advice on basic star-schema design (Date dimension)
- How to join dimension tables while populating a fact table if business key of one dimension table is not in the other joining table?
- Many-to-many from relational design to dimensional design
- How to fit a separate table in data warehouse model?
- Whether sales (fact) table should be made to have the userid from customer (dim) table in dimensional modeling?
- Should I use multiple fact tables for each grain or just aggregate from lowest grain?
- Designing a DW Model Diagram
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?

Dimensions should never link to other dimensions. The only exception that I normally make to this rule would be for dimensions with dates that would join to a date dimension. I'm sure there are other exceptions, but they're rare and I don't think they apply here.
So yes, the correct answer, based on what you provided, would be to recreate some of the DimStores dimension attributes inside of the DimSalesPersons dimension, based on the store that the salesperson is associated with. Depending on the type of dimension that DimStores is, your ETL processes will need to handle changes to an existing store record in both DimStores and DimSalesPersons. That's a pretty common design paradigm.