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 to allow a dynamic selection of a column for a measure in a chart,without using variable?
What are aggregate transformation?
What is factless fact tables?
What function should we use to display the value entered or selected by a user in response to a prompt?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
Explain piconet?
What is surrogate key? Where we use it? Explain with examples.
Explain is olap databases are called decision support system true/false?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain what is fact less fact table? Where you have used it in your project?
What is Snow Flake Schema design in database?
What are session timeout and application timeout?