What is slowely changing dimensions?why we are used SCD?
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
What is the difference between the content store and content manager?
How security is concerned with Reportnet? Explain its implementing steps.
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how to perform single sign in cognos by using url?
What is cognos reporting tool?
Explain the different types of views used in cognos.
What are all types of Batches?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What is the advantage of using shortcuts?
Can you define report item?
Can you define transformer?
How do you call a store procedure within a transformation?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Why cognos scenario is used?