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

Please explain the different stages in creating a report in cognos report net?

1056


what are the names of the reports that you prepared?

1159


what is stitch query in reportnet?

1155


what is the difference between filter and condition?

1113


What is called cognos reporting tool?

1098


how to create measures and dimensions?

1173


What is main advantage datawarehousing over oracle?

1039


what are the dimensions that you have in your current project?list them?

2109


Define cognos report net?

1010


which type of project we r going to snowflake schema

2021


How to deploy from one server to another server?

2541


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2260


What is called a slice?

1079


Can you define drill down and drill up?

1076


What is catalog and types of catalogs in cagonos and which is better?

1082