Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2506


What is Additive function?

2003


When we save a report in report studio with what extn it save?

1044


What are the different types of important services used in cognos?

995


What errors and types of errors you faced in Cognos ReportNet?

4163


what is the difference between filter and condition?

1047


How do we convert from Numeric to be Words?

2993


9. What was the most complex type of report you dealt with?

2191


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

2019


what is catalog and types of catalogs in cagnos and which is better?

1147


how you create security to reports?

1039


What is the difference between a cascading report and drill through the report?

1156


How is possible this scenario using in type-in prompt.?

1025


1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3547


How do you call a store procedure within a transformation?

985