This discussion is archived
13 Replies Latest reply: Feb 7, 2013 9:38 AM by Mark Malakanov (user11181920) RSS

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

User583772-OC Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points