| |
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. |
| May 05, 2007 07:33:10 |
#8 |
| Sriram N |
Member Since: Visitor Total Comments: N/A |
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 |
| |
Back To Question | |
