#data warehousing interview question

[tecktricks]

Role Playing Dimension in Data warehouse with Example

Role Playing Dimension in Data warehouse with Example

Continuing with our tutorial on Type of Dimension in data warehouse ,  we talked about to Conformed Dimension and Junk Dimension  and their importance in Data warehouse technology. In below article we will go through the Role Playing Dimension in data warehouse with some  example along with their .Hope you will enjoy this small data warehouse tutorial.

Role Playing Dimension Kimball definition

A…

View On WordPress

[tecktricks]

Degenerate dimension in Data warehouse with Example

Degenerate dimension in Data warehouse with Example

A degenerate dimension is a dimension which is derived from the fact table and doesn’t have its own dimension table. In below article we will discuss degenerate dimension in details.

Kimball definition of Degenerate Dimension

According to Ralph Kimball, in a data warehouse, a degenerate dimension is a dimension key in the fact table that does not have its own dimension table, because all the…

View On WordPress

[tecktricks]

Junk dimension in Data warehouse with Example

Junk dimension in Data warehouse with Example

Junk dimension are dimensions that contain miscellaneous data such as flags and indicators.  When designing a data warehouse, you might come across a source system that has a bunch of yes/no indicator fields. In below article we will discuss junk dimension in details.

What is Junk Dimension ?

When developing a dimensional model, we often encounter miscellaneous flags and indicators. These flags…

View On WordPress

[tecktricks]

Conformed dimension in Datawarehouse with Example

Conformed dimension in Datawarehouse with Example

A conformed dimension is a set of data attributes that have been physically implemented in multiple database tables using the same structure, attributes, domain values, definitions and concepts in each implementation. In below article we will discuss conformed dimension in details.

What is conformed Dimension ?

In data warehouse, conformed Dimension is the dimension which has the same meaning and…

View On WordPress

[tecktricks]

Difference between OLTP Vs OLAP system

Difference between OLTP Vs OLAP system

OLTP Vs OLAP : Discussion about difference between OLTP vs OLAP system. OLTP is operational system where as OLAP is analytical system.

OLTP

OLTP stands for Online Transaction Processing ,which typically involves the operational DATA involving the fast query processing, data updation . It basically holds the application data which is necessary to run our business.

is characterized by a large…

View On WordPress

[tecktricks]

operational systems vs data warehousing

operational systems vs data warehousing

Operational systems vs data warehousing : we started talking about data warehousing concept. If you already have some working experience of Operational data (Production data) , you must be wondering how different will be the Data warehouse data compared to operational Data . So in below tutorial , we will give some basic comparison of Data warehouse data and Operational data.

operational systems…

View On WordPress

[tecktricks]

Data Warehouse Architecture and component

Data Warehouse Architecture and component

In last tutorial ,we discuss about the data warehouse concept and their importance in data world.  We also checked some of the key feature is Data warehousing . In below tutorial , we will talk about Data Warehouse Architecture in details .We will discuss about the various steps involves in a data warehouse life cycle.

Data warehouse Architecture

Data warehouse Architecture 1. Data Source

Data…

View On WordPress

[tecktricks]

Data Warehousing Concepts and key features

Data Warehousing Concepts and key features

Data warehousing is an integral part of any effective business intelligence endeavour which help in determine effectiveness of business processes, create policy, forecast trends, analyse the market and much more. In below tutorial , we will talk about Data Warehousing Concepts , its features and types. We will also talk about the architecture of Data warehouse .

Data Warehousing Concepts

A data…

View On WordPress