Q: Why do we use surrogate key?
A1: Usually Surrogate keys are System Generated keys that can be used in place of missing primary key.
A2: A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data. A surrogate repres...
Q: What are the possible data marts in life insurance data warehouse project ?
A: Data Marts are considered as smaller logical subset of Data warehouse. DW is enterprise-wide while DMs are for Department Level. So DMs can be identified on the basis of what departments are there in ...
Q: What are the types of dimension tables?
A1: The Dimensions are Confirmed Dimension, Junk/Dirty Dimension, Degenerated Dimension and Slowly Changing Dimensions(SCD)-(Under slowly changing dimensions we have 6 types, they are Type1, Type2, Type3,...
A2: In a data warehouse, a dimension is a data element that categorizes each item in a data set into non-overlapping regions. The same category of information. For example, year, month, day, and week are.
A1: Usually Surrogate keys are System Generated keys that can be used in place of missing primary key.
A2: A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data. A surrogate repres...
Q: What are the possible data marts in life insurance data warehouse project ?
A: Data Marts are considered as smaller logical subset of Data warehouse. DW is enterprise-wide while DMs are for Department Level. So DMs can be identified on the basis of what departments are there in ...
Q: What are the types of dimension tables?
A1: The Dimensions are Confirmed Dimension, Junk/Dirty Dimension, Degenerated Dimension and Slowly Changing Dimensions(SCD)-(Under slowly changing dimensions we have 6 types, they are Type1, Type2, Type3,...
A2: In a data warehouse, a dimension is a data element that categorizes each item in a data set into non-overlapping regions. The same category of information. For example, year, month, day, and week are.
No comments:
Post a Comment