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

Conformed Dimension

Go down

 Conformed Dimension Empty Conformed Dimension

Post  Brindha Sun Jul 22, 2012 12:05 pm


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


Posts : 3
Join date : 2012-07-20

Back to top Go down

Back to top

- Similar topics

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