Answer Detail: RE: explain in detail about type 1, typ...

GeekInterview.com > Interview Questions > Data Warehousing > Concepts

Print |

Question: explain in detail about
type 1,
type 2(SCD),
type 3 ?

October 10, 2005 08:07:02	#3
Henry	Member Since: Visitor Total Comments: N/A
RE: explain in detail about type 1, typ...
SCD Type 1 : overwrite data is to be there. Type 2 : current, recent and history data should be there. Type 3: current and recent data should be there.