1.WHAT IS A DEGENARATIVE DIMENSION?
ans:A degenerate dimension is data that is dimensional in nature but stored in a fact table.
2. WHAT IS CONFORMED DIMENSION?
ans: a dimensional table which can be shared by multiple fact tables is known as conformed dimension
3.what is normalization?explain 3rd normalform
the process of organizing data to minimize redundancy is called normalization.
Normalization usually involves dividing large tables into smaller (and less redundant) tables
and defining relationships between them.
Third Normal Form (3NF): No duplicate information is permitted. So, for example, if two tables
both require a birthdate field, the birthdate information would be separated into a separate table,
and the two other tables would then access the birthdate information via an index field in the birthdate table.
Any change to a birthdate would automatically be reflect in all tables that link to the birthdate table.
4.what is denormalization?
Denormalization is the process of attempting to optimize the read performance of a database
by adding redundant data or by grouping data.
5.how can you receive a mapping specification document in word or xl format?
6.how can you identify a index on a column in a table?
7.how often should you contact ur clinet?
No comments:
Post a Comment