Data Models Best Practices — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Data Models Best Practices

edited Aug 6, 2020 9:51PM in Reporting and Analytics for HCM 4 comments

Summary

Are the Best Practices for Building Data Models using Tables vs. Views

Content

Wondering if there are best practice guidelines for building Data Models?

For example, when pulling manager data, there are several tables with this information,
PER_ASSIGNMENT_SUPERVISORS_F
PER_ASSIGNMENT_SUPERVISORS_F_
PER_ASSIGNMENT_SUPERVISORS_F_V

What is the general rule we should be following? (reference the view, the table, etc)
Is there better performance using one over the other?
 

 

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!