1 Reply Latest reply: Mar 26, 2013 9:24 PM by simmso RSS

    Source System contains Surrogate keys

    huny
      How to design dimension and facts when my source system table itself contains surrogate key (i mean auto generated id).......

      for example:
      EMP
      id PK
      name
      salary
      designation

      id is autogenerated sequence....... my dimension will contain this id as surrogate key but no natural key ...is it right?
      if it is right then i cannot create key map table for my dimension