13 Replies Latest reply: Feb 7, 2013 11:38 AM by Mark Malakanov (user11181920) RSS

    Identifying Primary Keys for table(s) which have no natural PK

    User583772-OC
      Hello,

      At my organization, a person used the loader to bring in 4 tables which have no natural PK's. The user is using BI Studio to demo to upper management. He wants to be able to get down to a single row returned, but the table(s) don't appear to have anything unique, and the data pulled from the warehouse has no timestamps, and only dates. Since there can be multiple occurrences of case names, supervisor names, worker names, case numbers, dates, etc. I have no idea how to get anything for sure down to a unique single row returned and this table has no other table in relation to it:

      Name Null Type
      ------------------------ ---- ------------
      APPROVAL_PERIOD VARCHAR2(50)
      PAGE_NUMBER VARCHAR2(50)
      SERVICING_AGENCY VARCHAR2(50)
      ELIGIBILITY_OVERRIDES_1 VARCHAR2(50)
      SERVICE_AUTH_OVERRIDES_1 VARCHAR2(50)
      SUPERVISOR VARCHAR2(50)
      ELIGIBILITY_OVERRIDES_2 VARCHAR2(50)
      SERVICE_AUTH_OVERRIDES_2 VARCHAR2(50)
      WORKER VARCHAR2(50)
      ELIGIBILITY_OVERRIDES_3 VARCHAR2(50)
      SERVICE_AUTH_OVERRIDES_3 VARCHAR2(50)
      TYPE_OF_OVERRIDE VARCHAR2(50)
      CASE_NUMBER VARCHAR2(50)
      CASE_NAME VARCHAR2(50)
      CC_PROGRAM VARCHAR2(50)
      PERIOD_BEGIN DATE
      OVERRIDE_REASON VARCHAR2(50)
      OVERRIDE_VERSION VARCHAR2(2)
      APPROVED_DATE DATE

      If anyone has some advice on how to proceed with this data I would appreciate it.