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 |
What are the various tools? Explain name a few?
What is MODEL is Data mining world?
Explain me what are data marts?
What is a Data Cube?
What is surrogate key? Explain with examples.
How to limit the max no of rows retrieved in the report?
How to calculate fact table granularity?
What is the use of incremental aggregation? Explain me in brief with an example?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain what are the advantages of query studio compared to report studio?
What is Bulk Insert?
Explain difference between data ware house & data mart?