What is slowely changing dimensions?why we are used SCD?
Answer Posted / nasa
these are three types
type-1
type-2
type-3
type-1: it will not maintain historical data... that means
if you update the record it store but it will remove
previous data
type-2: type -2 maintain historical data. it store new data
by row wise..
type-3: type-3 also maintain historical data but it stores
data column wise and it allow limited nearly 250
but type allow more that 250 so type-2 is the best...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please explain the different stages in creating a report in cognos report net?
what are the names of the reports that you prepared?
what is stitch query in reportnet?
what is the difference between filter and condition?
What is called cognos reporting tool?
how to create measures and dimensions?
What is main advantage datawarehousing over oracle?
what are the dimensions that you have in your current project?list them?
Define cognos report net?
which type of project we r going to snowflake schema
How to deploy from one server to another server?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What is called a slice?
Can you define drill down and drill up?
What is catalog and types of catalogs in cagonos and which is better?