Which Dimensional Model is better for performance and scalability?
Option 1:
MyFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
FirstAttemptCount,
SecondAttemptCount,
ThirdAttemptCount
Option 2:
MyFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
AttemptTypeFK,
AttemptCount
AttemptTypeDimension:
AttemptTypeId,
AttemptTypeName
Option 3:
FirstAttemptFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
FirstAttemptCount
SecondAttemptFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
SecondAttemptCount
ThirdAttemptFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
ThirdAttemptCount