Surrogate keys are generated on tables in the data warehouse after the table is populated.
TRUE
FALSE
Answers
Answered by
1
This statement is FALSE.
A surrogate key is a one of a kind recognizable proof key, it resembles a fake or option key to generation key in light of the fact that the creation key might be alphanumeric or composite key yet the surrogate key is constantly single numeric key.
Assume the item key is an alphanumeric field on the off chance that you make a record for this fields it will involve more space, so it is not prudent to join/list in light of the fact that for the most part, every one of the information warehousing truth tables are having authentic information.
These fact tables are connected with such a large number of measurement table, that if it's a numerical field the execution is high.
A surrogate key is a one of a kind recognizable proof key, it resembles a fake or option key to generation key in light of the fact that the creation key might be alphanumeric or composite key yet the surrogate key is constantly single numeric key.
Assume the item key is an alphanumeric field on the off chance that you make a record for this fields it will involve more space, so it is not prudent to join/list in light of the fact that for the most part, every one of the information warehousing truth tables are having authentic information.
These fact tables are connected with such a large number of measurement table, that if it's a numerical field the execution is high.
Similar questions