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 Posted / bluegems
Answer is c.)add time period simply and make it
not null.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the types of partitioning?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain multivalued dependency?
What are target types on the server?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
How to generate iqd file from framework manager?
Explain what is the difference between view filter and report filter?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain what are non-additive facts?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain what are the advantages of query studio compared to report studio?
What are various warehousing tools?
Explain what is analytical or analytic mean?
Explain about core dimension,
Explain what is a cube in data warehousing concept?