How to handle time period attribute for time dependent data??
a.)add time period as a part of pk b.)add time period simply
and make it nullablec.)add time period simply and make it
not null.
Answer / bluegems
Answer is c.)add time period simply and make it
not null.
Is This Answer Correct ? | 4 Yes | 1 No |
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How to calculate fact table granularity?
What is crass reference table?
What are session timeout and application timeout?
Explain what is partitioning? What are the types of partitioning?
What is the 4 + 1 view model as it relates to system modeling?
what is a hot file, why we need in datawarehousing, where we used in general
What are the advantages of raid 1, 1/0, and
Explain is fact table?
Explain dimensional modelling?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What are the different methods of loading dimension tables?