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
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is Additive function?
When we save a report in report studio with what extn it save?
What are the different types of important services used in cognos?
What errors and types of errors you faced in Cognos ReportNet?
what is the difference between filter and condition?
How do we convert from Numeric to be Words?
9. What was the most complex type of report you dealt with?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
what is catalog and types of catalogs in cagnos and which is better?
how you create security to reports?
What is the difference between a cascading report and drill through the report?
How is possible this scenario using in type-in prompt.?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
How do you call a store procedure within a transformation?