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 / navneet singh sahni

Slowely Changing Dimensions are those whose data are not
fixed.

SCD types:

SCD type 1: Whose data is not fixed. Historical data are
not saved. Data keeps on changing.-> Current Data

SCD type 2: Whose data is fixed and also save historical
data.

SCD type 3: like SCD type 2 only but save hostorical data
in another table. In one table data will updated and in
another table historical data will be there.

Depends what we are going to use a DWH or Database.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the content store and content manager?

986


How security is concerned with Reportnet? Explain its implementing steps.

1985


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1009


how to perform single sign in cognos by using url?

1083


What is cognos reporting tool?

1029


Explain the different types of views used in cognos.

890


What are all types of Batches?

979


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1647


What is the advantage of using shortcuts?

1111


Can you define report item?

984


Can you define transformer?

895


How do you call a store procedure within a transformation?

940


1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

2079


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2325


Why cognos scenario is used?

999