Techno functional

What are the source systems involved in Person Dimension?

• Peoplesoft and Salesforce

• Saleforces only

• Peoplesoft only

• MDM

Is the contact and person the same?

• They are same

• Contact is a subset of Person

• They are mutually exclusive

What type of SCD is the person Dimension

• I

• II

• III

• IV

Do we have recruiter information available in Person Dimension?

• Yes

• No

From where do we get eff_from_date and eff_to_date

• eff_from_date from EFF_DT

  eff_to_date from EFF_TO_DT

• eff_from_date from EFF_DT

  eff_to_date is Calculated

• eff_from_date is Calculated

  eff_to_date from EFF_TO_DT

• eff_from_date is Calculated

  eff_to_date is Calculated

Is headcount synonymous to our person information?

• Yes

• No

Do we have user data in dim_person?

• Yes

• No

PS_JOB vs PS_PERSONAL_DATA which is the proper source for Person Dimension?

• PS_JOB

• PS_PERSONAL_DATA

• None of these