What is diff b/w Alias and Contexts in which situation we
are using contexts instead of Alias?

Answer Posted / saichand

The main diffrence between them is if the loop is formed
between 1 fact table and 2(0r) more dimensions tables,then
create an alias for existing dimension tables.if loop
constitute more than one fact table then in this case go
for contexting.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is object stores?

583


Can we configure two instances of CMS pointing to two different CMS system databases?

1484


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

550


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1968


what are the day to day activities of BO administrator ?

1970






Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3843


How to execute the plsql procedure from the report by clicking with mouse?

613


Explain what is the difference between slice and dice and cross tab report?

605


Did you face any problems while creating reports? Name? Solutions?

3256


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1717


Explain when to use local filter and when to use global filter?

603


Explain what are the steps to be taken to schedule the report?

635


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

571


What is the difference between datawarehousing and businessintelligence?

612


In banking domain how many Fact tables,Dimension table are present?

8375