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?
Thanks! I appreciate your help.