What is a role playing dimension? In this video we define role playing dimension and provide two implementation strategy examples.
Watch this short video to learn how LeapFrogBI is transforming traditional data warehouse development into a fast and flexible process.
What is an EDW bus architecture? What is a bus matrix? This short video introduces the bus architecture.
What is a transaction fact tables? What is a periodic snapshot fact table? What is an accumulated snapshot fact table? This short video describes the three primary types of fact tables.
What is a mini dimensions? This short video describes mini dimensions and provides examples.
What is a Fact Table? What is a Dimension? This video introduces these key dimensional modeling objects.
What is a junk dimensions? This short video describes junk dimensions and provides examples.
Data warehouses provide organizations with a knowledgebase that is relied upon by decision makers. ETL (extract, transform, load) is the process that is responsible for ensuring the data warehouse is reliable, accurate, and up to date. This post presents a design pattern that forms the foundation for ETL processes. What are the goals? Before jumping […]
What is a degenerate dimensions? This short video describes these degenerate dimensions and provides examples.
What is a snowflake dimension? What is an outrigger dimension? This short video describes these two dimension types and provides examples.
What is an inferred member? What is an unknown member? Early arriving facts or late arriving dimensions require that fact record foreign key values be uniquely managed. In this video we cover a few common options.
What is a surrogate key? What is a foreign key? What is a business or natural key? It is important to know the meaning of these key types and others to effectively design and read dimensional models.