⟩ Explain me what are the key columns in Fact and dimension tables?
Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of fact tables are the primary keys of the dimension tables.
Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of fact tables are the primary keys of the dimension tables.
Explain what is Normalization?
What does subject-oriented data warehouse signify?
How many fact tables are there in a star schema?
List the Schema that a data warehouse system can implements?
Explain data mart?
Define metadata?
What is Summary Information?
Define dimension?
Please explain your supervisory style?
Explain about a short term plan you developed for your department/team/group?