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 / s
The answer should be option (a). Add time period as a part
of primary key
Is This Answer Correct ? | 1 Yes | 0 No |
How to load the time dimension?
Explain what are the vaious etl tools in the market?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain dimensional modelling?
What are the fundamental elements of the data warehouse?
What is hybrid slowly changing dimension?
What are loops in Datawarehousing?
What are the types of partitioning?
What is the capacity of power cube?
explain about balanced dimension,
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.
What is meant by metadata in context of a data warehouse?