Answer / vvm.sp

Subject of the mesurable data. Dimensions are mainly 11
types. They are
1. Changing Dimension
2. Slowly Changing Dimension
3. Rapidly Changing Dimension
4. Conformed Dimension
5. Degenerate Dimension
6. Junk Dimension
7. Inferred Dimension
8. Role Playing Dimension
9. Shrunken Dimension
10. Out Triggers
11. Static Dimension

Answer / 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".

Answer / shashiall

Dimensions contains Textual attributes.
It is Wide not Deep.(whereas FACT is deep not wide)

about Dimensions..

The Slowly Changing Dimensions Wizard creates mappings to
load slowly changing dimension tables:

Type 1 Dimension mapping. Loads a slowly changing dimension
table by inserting new dimensions and overwriting existing
dimensions. Use this mapping when you do not want a history
of previous dimension data.
Type 2 Dimension/Version Data mapping. Loads a slowly
changing dimension table by inserting new and changed
dimensions using a version number and incremented primary
key to track changes. Use this mapping when you want to
keep a full history of dimension data and to track the
progression of changes.
Type 2 Dimension/Flag Current mapping. Loads a slowly
changing dimension table by inserting new and changed
dimensions using a flag to mark current dimension data and
an incremented primary key to track changes. Use this
mapping when you want to keep a full history of dimension
data, tracking the progression of changes while flagging
only the current dimension.
Type 2 Dimension/Effective Date Range mapping. Loads a
slowly changing dimension table by inserting new and
changed dimensions using a date range to define current
dimension data. Use this mapping when you want to keep a
full history of dimension data, tracking changes with an
exact effective date range.
Type 3 Dimension mapping. Loads a slowly changing dimension
table by inserting new dimensions and updating values in
existing dimensions. Use this mapping when you want to keep
the current and previous dimension values in your dimension
table.


apart from these: there are...

Confirmed dimensions

Junk Dimensions
Degenerated dimension

Thanks...

Why do we use DSS database for OLAP tools?

2 Answers  

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

what is surrogate id ?

3 Answers   IBM,

---

How to display null values on a target & non-null values on a target?

3 Answers  

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

What is IQD file?

1 Answers  

---

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

What are variable ports and list two situations when they can be used?

1 Answers  

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---