Model design process seems like combine original tables with proper redundancy.
For example, we have 3 tables in database: brands/corps/shops,
Just put these fields together, and add table name as prefix to avoid conflict, we’ll get the final DWD table as follow:
