Question

As the senior analyst responsible for data staging, you are responsible for the design of the data staging area. If your data warehouse gets input from several legacy systems on multiple platforms, and also regular feeds from two external sources, how will you organize your data staging area? Describe the data repositories you will have for data staging.

Answer 1

Answer:

The corresponding schemas I use such as given below.

Explanation:

• Dim: Used in the design for certain artifacts belonging to measurements.
• Fact: Used for these artifacts throughout the design relevant to the truth
• Admin: Used for all configuration-related artifacts that could be open to professional end-users.
• Audit: That used to hold audit-related particles.
• Etl: Is used for keeping objects, particularly staging details, directly connected to something like the ETL method.
• Report: Used to keep objects utilized explicitly for programs for documentation.
• Olap: Used for keeping objects directly used for systems for study.
• Test: Used to carry objects which have been used exclusively for research.
• Useful- Used to carry objects that just about any member including its implementation may typically use.