Interested to Buy Any Domain ? << Click Here >> for more details...
What are Dimensions and various types of Dimensions?
- 3 Answers
- 42530 Views
- PayPal, TCS, I also Faced
- E-Mail Answers
Answer Posted / atul
Type of Dimension
Conformed Dimension
Dimensions are conformed when they are either exactly the
same (including keys) or one is a perfect subset of the
other. Most important, the row headers produced in the
answer sets from two different conformed dimensions must be
able to match perfectly.
Conformed dimensions are either identical or strict
mathematical subsets of the most granular, detailed
dimension. Dimension tables are not conformed if the
attributes are labeled differently or contain different
values. Conformed dimensions come in several different
flavors. At the most basic level, conformed dimensions mean
the exact same thing with every possible fact table to
which they are joined. The date dimension table connected
to the sales facts is identical to the date dimension
connected to the inventory facts.[1]
Junk Dimension
A junk dimension is a convenient grouping of typically low-
cardinality flags and indicators. By creating an abstract
dimension, these flags and indicators are removed from the
fact table while placing them into a useful dimensional
framework.[2]
Degenerated Dimension
A dimension key, such as a transaction number, invoice
number, ticket number, or bill-of-lading number, that has
no attributes and hence does not join to an actual
dimension table. Degenerate dimensions are very common when
the grain of a fact table represents a single transaction
item or line item because the degenerate dimension
represents the unique identifier of the parent. Degenerate
dimensions often play an integral role in the fact table's
primary key.[3]
Role-Playing Dimensions
Dimensions are often recycled for multiple applications
within the same database. For instance, a "Date" dimension
can be used for "Date of Sale", as well as "Date of
Delivery", or "Date of Hire". This is often referred to as
a "role-playing dimension".
| Is This Answer Correct ? | 27 Yes | 9 No |
Post New Answer View All Answers
What is Index Caches size?
What is the use of target designer?
What is meant by LDAP users?
In warehouses how many schemas are there?
What are the different lookup cache(s)?
What is the need of an ETL tool?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Write the unconnected lookup syntax?
What are the guidelines to be followed while using union transformation?
What is meant by lookup transformation?
what is the complex transformation you used in informatica
What is the need for an etl tool?
What are roles and groups and benefits of using them?
How do you load only null records into target?
What are the advantages of informatica?
