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.
- 1 Answers
- 5114 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bluegems
Answer is c.)add time period simply and make it
not null.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
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?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain bus schema?
What is scd1 , scd2 , scd3?
Who needs data warehousing?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is metadata in context of a datawarehouse and how it is important?
How can you implement many relations in star schema model?
Explain what are non-additive facts?
What is type 2 version dimension?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Explain what is a view as it relates to system modeling?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain what are the advantages data mining over traditional approaches?
