WorksheetsTechno functional
Total questions: 8
Worksheet time: 4mins
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
