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 are the different types of reports present in cognos?
-----------With out using DrillThrough how to do Reports?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
How create measures and demensions?
Define catalog in cognos and write its various types?
What are the types of catalogs in cognos?
How to create a cube in Transformer? What is the process? Please mention process thank u
What are all the types of report?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
What is difference between data mart and data warehouse?
Can you define metrics designer?
What is the report studio?
which type of project we r going to snowflake schema