0

I am designing a data mart for University students and confused about visa and passport information that should it go in the student dimension or should I define a separate dimension for it. Which would be the better approach?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
LondonUK
  • 437
  • 1
  • 8
  • 20
  • student applying for the university is a business process and the grain is to capture all the details related to the student/applicant. – LondonUK Mar 30 '15 at 19:51
  • Thanks Marek, This information could be useful to slice and dice the students data according to their nationality and the type of visas they hold. It is possible for a student to have multiple visas during their course of study but passport probably would be the same. – LondonUK Mar 31 '15 at 07:50
  • But can a student have more than one visa at a time? If not, add this information to the Student dimension and make it an SCD2 one. – Marek Grzenkowicz Mar 31 '15 at 19:56

0 Answers0