Interested to Buy Any Domain ? << Click Here >> for more details...
Aliases and Contexts Which once will give the better
performence when resolve the loops?
- 3 Answers
- 8711 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / vasanth
alias is used when two dim tables and one fact table are there in the loop ,alias is used for one dim table which has less outer joins.
Context are used when there are 2 fact tables and one dim table in the loop,we create context for one join between one fact and dim in the loop.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the difference between slice and dice and cross tab report?
how to create reports on screech?
what is universe null
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?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain when we use aggregate awareness function in designer?
Explain is there any default username & pwd for bo designer & supervisor?
8. How much supervision have you typically received in your previous job?
When to use local filter and when to use global filter?
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
Explain when to use local filter and when to use global filter?
How would you format some text using css to be verdana and bold?
Explain in detail about type 2(scd),
