DWH Table option: Physical Raw Table

Suggestion from a partner:

If all data processing and validation has been made on stage, it could sometimes be useful if you could implement the raw data warehouse table as a view on the valid Staging table instead of having a physical table. 

There might be some feature that should be disabled for view-based raw tables, like lookups etc - and also transformations if both Raw and Valid tables are view-based.

1 comment

Please sign in to leave a comment.