Interested to Buy Any Domain ? << Click Here >> for more details...
What are Dimensions and various types of Dimensions?
- 3 Answers
- 42374 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 a predefined event?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to generate sequence numbers using expression transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Enlist the advantages of informatica.
What does command task mean?
How to create Target definition for flat files?
What are junk dimensions?
Whats there in global repository
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the use of transformation?
What are some examples of informatica etl programs?
What is the different lookup cache(s)?
