Interested to Buy Any Domain ? << Click Here >> for more details...
What is slowely changing dimensions?why we are used SCD?
- 2 Answers
- 7113 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 difference between drill through, drill across?
What actually a project contains?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,
1. Differences between Merge and Union In Cognos?
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
how u create cubes in ur project
What are the ways to import data into catalog?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is the use of report studio?
how to convert crosstab into list?
Teradata 
