A schema is nothing but a collection of objects
A star schema design is a data base design where the centrally located table is called fact table with surrounded by number of dimensional tables
Learn the core features of Cognos and become master with our expertise tutorials.
Snow flake schema:
|Star schema||Snow flake schema|
|It is de normalizedRetrieval up data is faster redundancy is there||it is normalizedRetrieval up data is slower due to more number of icons redundancy can be reduced|
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