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 / s
The answer should be option (a). Add time period as a part
of primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Explain what is fact less fact table? Where you have used it in your project?
Explain what are fact, dimension, and measure?
How do we design a universe?
Explain dimension table ?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Explain differences between star and snowflake schemas?
Database in use is oracle?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is the difference between view filter and report filter?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What are the different models used in cluster analysis?
How to calculate fact table granularity?
Explain degenerate dimension table?