what ever changes done in source for each and every record there is a new entry in target side, whether it may be UPDATE or INSERT and in target mentaining the history. If Not clear then reach me at 09910232910
Let me give an example to make the point clear....
Like account information is usually maintained in two categories:
Current Account and other is Time of Event Account i.e We have two set of tables eg CUR_ACCT this is fast moving dimension containing information like Balance etc , while the other is TOE_ACCT table this contains information like Contact Details, Phone No where history is not only important but considered to be changing slowly.
With this respect TOE_ACCT table qualiefies as slowly changing dimension.
Hybrid SCDs are combination of both SCD 1 and SCD 2.
It may happen that in a table, some columns are important and we need to track changes for them i.e capture the historical data for them whereas in some columns even if the data changes, we don't care.
For such tables we implement Hybrid SCDs, where in some columns are Type 1 and some are Type 2.
Hybrid SCDs are combination of both SCDÂ 2 and SCD 3.
Whatever changes done in source for each and every record there is a new entry in target side, whether it may be UPDATE or INSERT. There is new column added to provide the previous record info (generally it will be surrogate key)