What is hybrid slowly changing dimension?
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.