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 an olap designer?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What are slice and dice?
-----------Diff b/w OLAP and RDBMS?
can we insert all types of charts in a list report? what r the realtime prompts?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
How do you improve the performance of the Cognos Analytics report
What is the difference between the standard and metrics folder?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
Can you explain dynamic query mode?
what is the main advantage of impromptu over cognos reportnet?
What are all the types of indexes in Cognos?
What is the difference between Open Connection command ang Open Session Command?
What is called a slice?
Define metrics studio?