Answer / 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.

Answer / narender reddy

Join path: a join path is a series of joins that a query can use to access data in the tables linked by the joints. Join path problems can arise from the limited way that lookup and fact tables are related in a relational data base. The three major join problems that you encounter when designing a schematic are the following:
1. Loops
2. Chasm traps
3. Fan traps

Queries can return incorrect results due to the limitations in tha way that joins are performed in relational databases.

Loops: joins between tables form a continues path
Solved by: shortcut join(3 tables), aliases( more than 3 tables with one fact table), context( more than 3tables with more than one fact table),

Chasm traps: many to one joins from two fact tables converge on a single lookup table. This type of join convergence can lead to a join path problem called as a chasm trap.
Solved by: context, creating multiple SQL statements for each measure, creating multiple universes( webi only),

Fan traps: a one to many join links a table which is in turn linked by a one to many join. This type of serial many to one joins can lead to a join path problem called a fan trap.
Solved by: alias, using multiple SQL statements for each measure, creating the context using the alias.

Aliases: An alias is a table that is a exact duplicate of the original table, with a different name. The data in the table is exactly the same as the original table. Using aliases resolve loops and fan traps.

Context: context is a collection of joins which provide a valid query path for user to generate SQL. Using contexts we can resolve loops and chasm traps and assisting in some solutions of fan traps.

-------- when we use alias to resolve the loop we are using extra duplicate table, if we have more tables in schema it will decrease the performance so alias always decrease the performance compair to context.

Answer / raj

*If a loop contains only one lookup table then the loop can be resolved by detecting the alias.
*If a loop is having 2 or more fact tables (multiple fact tables) then the loop can be resolved by
detecting context.

Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

2 Answers   iFlex,

---

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

---

Can we take report on Excel in Business Objects?

6 Answers   Business Intelligence Analytics, Oracle,

---

. User wants to modify a report and wants to add additional data. How will you approach.

2 Answers  

---

what is BIAR file in business objects xi r2

3 Answers   TCS,

---

---

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest

3 Answers  

---

What is the architecture of ur project? can u explain it? PLz

1 Answers   Patni,

---

WHAT KIND OF TOOL BO IS?

7 Answers  

---

I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,

---

Can anyone plz tell me How to create universe in business objects enterprise 11.5

3 Answers  

---

7.what is data mart?

7 Answers   TCS,

---

what are slowly changing dimensions, confirm dimensions?

1 Answers   Wipro,

---