I am a solution architect for a global tech company with over ten years of experience.
What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
One dedicated layer for staging, one for type 1 persistent tables, and a dedicated schema/layer for tables at a dimensional model?
Why it is not recommended to have all tables in one schema?
I appreciate your help.