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 |
Explain vldb?
what is query optimizer? what are different types of optimizer s supported by oracle ?
Explain the difference between oltp and olap?
What is freehand sql?
Explain functional dependency?
What are the main steps to build the data warehouse?
What is DTS ?
if we increase the number of dimensions will the rows in fact table increase or decrease??
what is the difference between aggregate table and fact table ? how do you load these two tables ?
Explain the structure of cold fusion?
Whether dimension table can have numeric value?
What is the difference between olap and oltp?