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

Define query studio?

1009


What is metric store database?

1005


How to create a cube in Transformer? What is the process? Please mention process thank u

1770


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

1174


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

2060


What do you understand by user class in cognos?

954


dumps needed ASAP for - C2020-180 Cognos IBM Certification

2205


Can you define snapshot?

929


What is the size of database for you project?

1597


What do you understand by the term 'aggregate advisor?'

968


how to merge 2 crosstabs thans

2643


What is dtm?

1174


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1937


What do you understand by the term 'dynamic cube'?

1020


What you mean by drill across and what is the difference between drill through, drill across?

1028