Define Normalization, Fact Tables,
Foreign Key, Identity column, Seeding
Normalization is a breaking down of complex tables into
more tables to reduce redundancy and for performance.
Fact Tables= Fact tables is a
measurable tables of all the dimension tables. So It is attached to all
dimension tables. All the numeric data are stored in fact tables.
Foreign Key= It is constraint
used for data integrity and relationship with the primary table
Identity column= It
is a column where all values are unique like a primary key. For example
Identity(1,1) means , it starts from 1 and increased by 1 in every row
No comments:
Post a Comment