Interested to Buy Any Domain ? << Click Here >> for more details...
What is slowely changing dimensions?why we are used SCD?
- 2 Answers
- 7072 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / navneet singh sahni
Slowely Changing Dimensions are those whose data are not
fixed.
SCD types:
SCD type 1: Whose data is not fixed. Historical data are
not saved. Data keeps on changing.-> Current Data
SCD type 2: Whose data is fixed and also save historical
data.
SCD type 3: like SCD type 2 only but save hostorical data
in another table. In one table data will updated and in
another table historical data will be there.
Depends what we are going to use a DWH or Database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is the difference between List and Cross tab? Could some on explain with an example..
How to create Events?
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
How to configure the Cognos configurations to work in the Windows 2000 Server machine?
Hi Experts, Can a single package be shared by multiple users?
How to pass multiple values from picklist prompt to sub report filter?
if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me
Can you define query studio?
What is Dynamic Grouping? what is diff between grouping n levelspan?
difference between drill through and master detail report?
I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!
Teradata 
