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
Define query studio?
What is metric store database?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is the difference between a cascading report and drill through the report?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What do you understand by user class in cognos?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Can you define snapshot?
What is the size of database for you project?
What do you understand by the term 'aggregate advisor?'
how to merge 2 crosstabs thans
What is dtm?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What do you understand by the term 'dynamic cube'?
What you mean by drill across and what is the difference between drill through, drill across?