Interested to Buy Any Domain ? << Click Here >> for more details...
What are Dimensions and various types of Dimensions?
- 3 Answers
- 42225 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
server hot-ws270 is connect to Repository B. What does it mean?
What is option by which we can run all the sessions in a batch simultaneously?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is native users?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is workflow? What are the components of the workflow manager?
Under what condition selecting sorted input in aggregator may fail the session?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the function of aggregator transformation?
EXL informatica Questions
What is informatica powercenter repository?
Enlist the various types of transformations.
what is index?how it can work in informatica
How do you load first and last records into target table?
How do you convert single row from source into three rows into target?
