Confirm dimension: It is the dimension that is sharable across the multiple facts or data model. This is also called Role Playing Dimensions.
Junk dimension: A number of very small dimensions might be lumped (a small irregularly shaped) together to form a single dimension, a junk dimension – the attributes are not closely related. Grouping Random flags and text Attributes in a dimension and moving them to a separate sub dimension is known as the junk dimension.
Degenerated dimension: In this degenerate dimension contains their values in the fact table and the dimension is not available in the dimension table. Degenerated Dimension is a dimension key without a corresponding dimension.
Example: In the PointOfSale Transaction Fact table, we have:
Date Key (FK), Product Key (FK), Store Key (FK), Promotion Key (FP), and POS Transaction Number
Date Dimension corresponds to Date Key, Production Dimension corresponds to Production Key. In a traditional parent-child database, POS Transactional Number would be the key to the transaction header record that contains all the info valid for the transaction as a whole, such as the transaction date and store identifier. But in this dimensional model, we have already extracted this info into other dimensions. Therefore, POS Transaction Number looks like a dimension key in the fact table but does not have the corresponding dimension table.
Posted Date:- 2021-09-28 00:43:05
What is the Cube dimension?
What are MOLAP and its advantage?
What are the types of storage modes?
What is the use of AttributeHierarchyVisible?
What is the use of AttributeHierarchyOptimizedState?
What is the use of AttributeHierarchyDisplayFolder property?
What are calculated members and what is its use?
What is the use of IsAggregatable property?
What are a star, snowflake, and star flake schema?
What are confirmed dimensions, junk dimension, and degenerated dimensions?
How many types of dimensions are there and what are they?
How many types of attribute relationships are there?
What Is Rolap And Its Advantage?
What Is Molap And Its Advantage?
Give a brief view of the steps involved in backup SSAS.
What Is Scd (slowly Changing Dimension)?
What Is Role Playing Dimension With Two Examples?
Give a brief idea on the different languages used in SSAS?
How Many Types Of Relations Are There Between Dimension And Measure
Explain the types of dimensions in short words?
What Is Regular Type, No Relation Type, Fact Type, Referenced Type, Many-to-many Type With Example?
What do you understand about a rigid and flexible relationship? Which type of relationship is better for the performance?
What is a Factless fact table?
What are types of SCD?
What is the maximum size of a dimension?
For a measure group, can you estimate the number of minimum and maximum partitions required?
Can we hide an attribute?
What Are Calculated Members And What Is Its Use?
Explain the terms data warehouse and data mart. Elucidate the differences between them.
What is attribute hierarchy, and why is Attribute Hierarchy Display Folder property used?
What is perspective, have you ever created perspective?
What is the minimum and maximum number of partitions required for a measure group?
How in MDX query can I get the top 3 sales years based on order quantity?
How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?
After creating the cube, if we added a new column to the OLTP table then how do you add this new attribute to the cube?
What is AMO?
What is the Factless fact table?
What is the fact table?
How will you add a new column to an existing table in data source view?
What is Time Intelligence? How is it implemented in SSAS?
What is a data source view or DSV?
What is a datasource or DS?
What MDX functions do you most commonly use?
Name a few Business Analysis Enhancements for SSAS?
What is processing?
What is WriteBack? What are the pre-conditions?
What are the different ways of creating Aggregations?
What are the roles of an Analysis Services Information Worker?
What is a RAGGED hierarchy?
What is a RAGGED hierarchy?
R4R provides SSAS Freshers questions and answers (SSAS Interview Questions and Answers) .The questions on R4R.in website is done by expert team!
Mock Tests and Practice Papers for prepare yourself..
Mock Tests, Practice Papers,SSAS interview questions for experienced,SSAS Freshers & Experienced Interview Questions and Answers,SSAS Objetive choice questions and answers,SSAS Multiple choice questions and answers,SSAS objective, SSAS questions , SSAS answers,SSAS MCQs questions and answers
R4r provides Python,General knowledge(GK),Computer,PHP,SQL,Java,JSP,Android,CSS,Hibernate,Servlets,Spring etc Interview tips for Freshers and Experienced for SSAS fresher interview questions ,SSAS Experienced interview questions,SSAS fresher interview questions and answers ,SSAS Experienced interview questions and answers,tricky SSAS queries for interview pdf,complex SSAS for practice with answers,SSAS for practice with answers
You can search job and get offer latters by studing r4r.in .learn in easy ways .