Conformed Dimension

View previous topic View next topic Go down

Conformed Dimension

Post  Brindha on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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