In this presentation on dimensional data modeling, we explore idempotent pipelines and slowly changing dimensions.
You can find options to buy here
Or you can login here