Interested to Buy Any Domain ? << Click Here >> for more details...
What is slowely changing dimensions?why we are used SCD?
- 2 Answers
- 7202 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can you explain cognos planning?
What DB View and Bus View?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
Can we test the report other than manual testing?
Define cognos report net?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What is a dimension?
------------ Diff b/w MemberCaption and MemberDescription?
What is defined as data mining?
What is difference between primary key and unique key constraints?
-----------With out using DrillThrough how to do Reports?
What is cognos connection?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
How can we Maintain the Cube Security by Category level and Dimension level ?
