| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: What are Dimensions and various types of Dimensions?
Answer: 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. |
| April 04, 2007 03:28:23 |
#3 |
| vizaik |
Member Since: March 2007 Total Comments: 27 |
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 |
| |
Back To Question | |
