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
1. Explain your project.
Can you define drill across?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What are the advantages of shortcuts?
what is log in cognos?
How is possible this scenario using in type-in prompt.?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
how to create measures and dimensions?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
what is the difference between filter and condition?
Define catalog in cognos and write its various types?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
What are the different kinds of panes included in cognos?
What are the types of studio present in Cognos?