Interested to Buy Any Domain ? << Click Here >> for more details...
what is slowly growing dimension??
- 6 Answers
- 17495 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naresh
slowly changed/growing dimentions are 3 types
scd1 : it displays only current information it does not
display any historical infomation.
scd2 : it displays current + Historical information(full
histiry)
scd3 : it displays partial historical information not full
history
ex: bank mini statements last 10 trasactions
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / y.nagendra reddy
A DIMENSION WHICH IS CHANGED OVER A PERIOD OF TIME IS CALLED
AS A SLOWLY CHANGING DIMENSION OR SLOWLY GROWING DIMENSION.
THERE ARE 3 TYPES.
1.SCD TYPE1:IT STORES ONLY CURRENT DATA.
2.SCD TYPE2: IT STORES HISTORICAL DATA.
3.SCD TYPE3: IT STORES CURRENT AND PREVIOUS DATA.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / aakanksha
Well its actually the concept of SCD (Slowly changing
deimension)which are of three types type1,type2,type3
Type1:-keeps the information about the current record and
no history is maintained it it.
Type2:-Keeps the proper historical information by including
a surrogate key or we can say a flag which will indicate or
point to the currwent information.
Type3:-Keeps the partial historical information we main
tain it by keeping or including two columns say start date
and end date but it si not that much helpful as compare to
the type 2 slowly changing dimension as type 2 provides
more information than type3 .
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / ravikiran patil
The Dimension of Type 2 and Type 4 may be called as slowly growing dimension
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
slowly growing dimension means Slowly changed dimensions
that means the name it self defines the data which will
change periodicaly.There are 3 diff types of SCD's they are
1.scd-TYPE-1
2.scd-TYPE-2
3.scd-TYPE-3
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / 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 |
what is sdibling function tell me the some functions
Explain how data modeling is useful to cognos in daily life?
What is Conditional block? How do you use in a report?
------Diff B/W DrillThrough and master and Detailed Report?
What are all the types of report?
write a query to display to 10 max record from the employee table?
------------------- What is Busschema?
what is log in cognos?
Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
difference between drill through and master detail report?
What do you mean by Drill down and Drill Up?
Teradata 
