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 meant by slowly changing dimensions?

Answer Posted / surya

Master data occur in the OLTP system and that can't change
regularly,When the changes are occured in the OLTP
system,that changes can be handle by the dimension
tables.Such type of dimensions is called Slowly changing
dimensions.

There are three types of dimensions
TYPE1(Maintain only current data)
TYPE2(Maintain complete historic data)
TYPE3(Maintain one historic data)

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

988


Can more than 1 metric be applied on an analytic in business objects?

2171


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1021


Explain when we use aggregate awareness function in designer?

1027


How were the reports scheduled and how to resolve unexecuted documents?

2675


What we need to discuss with designer before starting the universe designing.

2252


Explain what three things do you consider to be the most important factors for a manager?

1011


Explain which versions are used in the bo dashboard work?

1094


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10894


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1530


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10401


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1050


Explain about a tricky situation for which you found a very simple solution?

1007


What Is The Difference Between Oltp And Olap?

1127


Explain what task is 98% of the required work of a business analyst?

1104