Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aravalli rajasekhar
There are many types of dimensions
conformed dimesion:
the dimension which are maintain the relation ship between
two are more fact table are called conformed dimension.
eg: galaxy schema
shrunk dimesion:
the dimnesion which does not maintain the direct relation to
fact table is called shrunk dimesion
junk dimesion:
the dimesion which are maintain the relation ship low
coradinality values is called junk dimension
eg: the dimsion apply on dimesion gender
rolepaly dimesion:
the dimesion which are occred more than two dimension tables
are called rolepaly dimension
eg: time appear frequently all dimension tabsles
dirt dimesoion:
the dimesion which are already occred in the fact table
but again apper with version change those dimension are
called dirty dimesion
eg: SCD2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain degenerate dimension table?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is data cleaning? How can we do that?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Suppose we want to display zero when null values coming to report how can we do that?
What is crass reference table?
What is real-time datawarehousing?
What are algorithms provided by Microsoft in SQL Server?
What is cfapplication tag?
What are the mapping paramaters and maping variables?
What is a functional dependency f said to be minimal?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are components of report studio?
Explain dimension table ?
