What are Dimensions and various types of Dimensions?
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
update strategy transformation in informatica
What could be the possible resons of locks by user?
is it possible to index the data in cache of lkp transformation ?
On which transformations you created partitions in your project?
What is dimensional table?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Why do we need informatica?
Is it possible to revert a global repository to local one and why?
What is a code page?
What is aggregate cache in aggregator transformation?
permutations of mapplet
What is decode in informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain why we use partitioning the session in informatica?