Informatica - What are Dimensions and various types of Dimensions?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 6 of 629

What are Dimensions and various types of Dimensions?

set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.

Total Answers and Comments: 23

Last Update: November 17, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 3

« First

Last »

May 08, 2006 00:48:14

md.rahman

RE: What are Dimensions and various types of Dimension...

Dimensions are classified to 3 types.

1.SCD TYPE 1(Slowly Changing Dimension): which contains current data.

2.SCD TYPE 2(Slowly Changing Dimension): which contains current data,+complete historical data.

3.SCD TYPE 3(Slowly Changing Dimension): which contains current data.

Is this answer useful? Yes | No

May 08, 2006 03:34:18

mrahman

Member Since: May 2006 Contribution: 3

RE: What are Dimensions and various types of Dimension...

The DWH contains two types of tables,

1.Dimension table 2.Fact table.

The Dimensions are classified 3 types.

1.SCD TYPE1(Slowly Changing Dimension) : contains current data.

2.SCD TYPE2(Slowly Changing Dimension) : contains current data + complete historical data.

3.SCD TYPE3(Slowly Changing Dimension) : contains current data + one type historical data.

Is this answer useful? Yes | No

April 04, 2007 03:28:23

vizaik

Member Since: March 2007 Contribution: 30

RE: What are Dimensions and various types of Dimension...

See dude rahaman,

scd1 is usual as you said : current data.
scd2 is usual as you said: current data + historical data.
scd3 is unusual : current data + just previous overwritten data.

than q

Is this answer useful? Yes | No

April 14, 2007 10:17:53

sharath S. N.

RE: What are Dimensions and various types of Dimension...

Dimensions table keeps the context of measure/metric indicated in the fact table
Dimension table answers on of the following questions

(1) Who purchased ?
(2) What was purchased?
(3) When it was purchased?

Is this answer useful? Yes | No

April 18, 2007 01:55:43

Sudheer Reddy

RE: What are Dimensions and various types of Dimension...

Dimensions are the tables that contains vital information to analyse the business.
There are degenerated dimensions, confirmed dimensions, junk dimension, time varient dimensions.

Is this answer useful? Yes | No

May 01, 2007 00:36:03

naga_wh

can u pls explain me

Can you pls explain me what is degenerated dimensions, confirmed dimensions, junk dimension, time varient dimensions

Is this answer useful? Yes | No

May 07, 2007 04:20:45

vijay

RE: What are Dimensions and various types of Dimensions?

The data warehousingÂ is logical or physical? explain? whatÂ is difference between two(logical&physical)?

Is this answer useful? Yes | No

May 09, 2007 07:33:10

Sriram N

RE: What are Dimensions and various types of Dimension...

Dimensions are attributes or some times tables.

Types

1) Slowly growing dimensions
2) Slowly changing dimensions(SCD)

         1) Type 1 SCD
         2) Type II SCD
         3) Type III SCD

Is this answer useful? Yes | No

May 22, 2007 04:51:40

Hemant

RE: What are Dimensions and various types of Dimension...

Please check SCD2 and SCD3 again. SCD2 contains the current as well as the latest previousÂ record but SCD3 contains the current as well as the entire historical records

Is this answer useful? Yes | No

May 22, 2007 06:56:00

#10

Rahul

RE: What are Dimensions and various types of Dimension...

A dimension is an object with respect to which the analysis is being made.
Various types of dimensions are Confirmed Dimension, Junk Dimension, .........

Is this answer useful? Yes | No

Page 1 of 3

« First

Last »

Go To Top