What is slowely changing dimensions?why we are used SCD?
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
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
Why cognos decision stream is used?
Can you define cognos powerplay?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
---------------Tell me about DWH Concepts?
Can you explain new content durability?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
how can I test reports in cagnos?
which type of project we r going to snowflake schema
What are the services provided in cognos 8?
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.
What is the use of cognos decision stream?
Define query items?
Define datastores in cognos?