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 |
What is scd1 , scd2 , scd3?
Why facts table is useful in representing the data?
5.Explain ODS ?
if you use oracle sql*loader , how do you transform data with it during loading?
What is Discrete and Continuous data in Data mining world?
What are the advantages of cold fusion?
Explain what is the difference between power center & power mart?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Why is chameleon method used in data warehouse?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is the capacity of power cube?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?