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
What is meant by alternate drill down with ex?
What are types of batch available in cognos?
-------------How you design DWH?
What are the types of catalogs in cognos?
What are all the types of indexes in Cognos?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What do you understand by the cognos?
-----------------What is Determination Model?
Why cognos decision stream is used?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What do you mean by Drill down and Drill Up?
What is the report studio?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
9. What was the most complex type of report you dealt with?