I’m thinking on using fivetran + dbt for my next Dwh project. I have one question, fivetran syncs the tables that I need to create My facts and dims tables. From what I know, usually we truncate the tables before loading the data from source system. This way we can really do a nice incremental load.
After all if I have a staging area from 1TB it does not make since to keep it forever there and reload all the facts and dim for multiple years if I just want to load 1 day.
Is there anyway approach to deal with this? Like delete the data from the staging area after it was inserted into the dim and fact tables