It is a dimension which is shared by multiple fact tables Ex: customer dimension, time dimension
It is a process of connecting multiple fact tables with PK-FK relationship
A slowly changing is a dimensions which captures the changes occurs over a period of time
SCD type 1 It contain only current data SCD type 2 It maintain couple history and current data SCD type 3 It maintain partial history (or) recent history and current data Surrogate key It is a system generated key which access primary key in the dWH tools maintains the uniqueness.
Interested in mastering Cognos Training? Enroll now for FREE demo on Cognos Training.
OLAP It is a interface (or) a gate way between the user and data source (dWH) (or) It is a set of specifications with allows the client application (report application) to query the data from data source and displays the data and to report
It is a OLAP used to query the data from desktop database like Dbase, fox, ms access, ckpper. While generating the report online
It is used to query the data from multidimensional source like cube and DMR model (dimensional relational model) to perform multidimensional analysis.
It is a process of viewing the data at different levels of details
Navigating from lowest level to highest level
Navigating from highest level to lowest level
It is a combination of both ROLAP and HOLAP it can query the data from the relational sources as well as multi dimensional sources like cognas.
In conceptual modeling face, database models conform or decide the dimensional tables and fact tables required for a particular data ware house design.
In logical modeling database modelers start creating relation between the tables logically
In physical modeling database modelers creates dimensional tables and fact with relations physically in the database For indepth understanding Cognos Training click on
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox