ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
what is meant by slowly changing dimensions?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is meant by slowly changing dimensions?
Answer
# 1		 
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 ?    2 Yes 0 No
Surya
 
  Re: what is meant by slowly changing dimensions?
Answer
# 2		 
Dimensions that change over time are called Slowly Changing 
Dimensions. There are three types namely,
1) Overwriting the old values
2) Creating an another additional record
3) Creating new fields
 
Is This Answer Correct ?    5 Yes 0 No
NareshKumar
[Chennai]
 
 
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
7.what is data mart? TCS6
Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?  3
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report ) Exilant5
What are the different types of Filters available in BUSINESS OBJECTS?  1
why do we use crystal reports rather than webintelligence reports ? Tech-Mahindra4
what is profile and packages in BOXI??  1
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab???? Keane-India-Ltd2
@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint? iGate2
what is meant by slowly changing dimensions? TCS2
When is the Repository created?  1
can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?  2
HOW TO INSTALL BOXI  1
What is the use of BO SDK?  4
what is zero client and thin client ? Tech-Mahindra2
Types of universes in business objects? TCS9
What is a loop? How can we overcome?  4
in universe perameter u dont give the option multiple contexts ,what is the impact in report level Accenture2
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in  2
i want to take a report 10 records per page. How to take it? is there any paging option in BO? IBM1
When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)? IBM4
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com