Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Conformed Dimension

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Conformed Dimension Empty Conformed Dimension

Post  Brindha Sun Jul 22, 2012 12:05 pm

Hi,

How to handle the conformed dimensions.
1 .Granular fact table -(Empid,ActivityDate,Duration,Reason,Flag)
2.Aggregated fact --(Empid,Induration,Outduration,Reason,Month,Year)
3.Master calendar- (Date,Month,Year,Quarter)
4. Dimension- (Empid,Alignmentcode,Alignstartdate,Alignenddate)
5- Dimension- (Alignmentcode,Code_Effectivedate,Code_expirydate,Month,year,Workingdays)

Could somebody suggest the best way of handing the conformed dimension and get the best data model

Brindha

Posts : 3
Join date : 2012-07-20

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

 
Permissions in this forum:
You cannot reply to topics in this forum