How we do incremental loading for dimensions?
In a
dimensional model, we may perform incremental loading for dimension tables
also. One may argue that this won’t be necessary as data volume in dimension
tables are not as high as the data volumes in the fact tables, hence we can
simply do a full load every time.
I personally
do not agree to this argument. This is because during the last few years I have
seen tremendous growth in the data in dimension tables and things can get quite
heavy especially if we are trying to load SCD type 2 dimensions. Anyway, without
much ado, let's delve deep.
No comments:
Post a Comment
Thank you :
- kareem