Interested to Buy Any Domain ? << Click Here >> for more details...
What is slowely changing dimensions?why we are used SCD?
- 2 Answers
- 7068 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
where you can save the report net documentation in our local system?
Can you define cube?
Define query items?
What is a dimension?
------------ Diff b/w MemberCaption and MemberDescription?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What are the components of report net?
What do you mean by drill through report?
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
can we insert all types of charts in a list report? what r the realtime prompts?
How can I schedule reports in cognos?
Why need staging area database for dwh?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What do you mean by drill across?
What are shortcuts? Where it can be used? What are the advantages?
