Answer Posted / numbsyd
it's been days since the question was asked and no one
bothered answering,never mind. since i gained some knowledge
about the term 'growing' dimension after the question was
aked in the interview, i'm giving the answer.
among three SCD's, one updates the existing dimension
leaving no traces of history and lets ignore this, the
second stores historical data with a surrogate key and
maintains complete history, the third records partial history.
among all these, apparantly the second dimension is the only
growing dimension in contrast to the third SCD. they
sometimes call it Second dimension as well, you know why??
just because they could
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is the deployment requirements used in cognos?
What are the types of studio present in Cognos?
What is the enterprise class platform architecture of cognos 8?
What are the different kinds of panes included in cognos?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What is meant by junk dimension?
What are the services provided in cognos 8?
Can you define report item?
what are the features in cognos8ui
What are cognos connection initial page components?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is the metric store database?
Define query studio?
how to create measures and dimensions?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??