How we will see which trap(Chasm trap or Fantrap) was used
in the Universe ?
- 2 Answers
- 8030 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sree
visually we can find out the traps, there is no option is
available in BO designer level.
Fan Trap: it is nothing but One-to-Many joins path is
occured from (fact to Dimension), using aliases we can
resolve the fan trap.
Chasm Trap: it is nothing but Many-to-One join path,
i.e.,single lookup table converging into more than one fact
table is called "chasm trap'. Using context we can resolve
the chasm trap.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / aanonymous
In universe structure panel,
Organize the dimension tables and fact tables after making the
possible joins. Look at the
joins and cordialities from Dimension tables to Fact table.
If majority of the joins (one-to-many)towards fact from
dimension table consider as Chasm trap.
If majority of the joins away from the Fact table and
towards dimension table(s) consider as Fan trap
If it is Fan trap, Alias is the recommended method to
resolve the loop, otherwise use the context.
We can use either of that or both of them.
| Is This Answer Correct ? | 5 Yes | 6 No |
Tell me about a complicated object you have created?
i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?
difference between web intelligence,crystal reports and desktop intelligents
Explain about a tricky situation for which you found a very simple solution?
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
How were the reports scheduled and how to resolve unexecuted documents?
Explain what are the measure objects?
Explain how many universes can be created in a project?
12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?
how many micro cubes can a report can have
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
0 Answers Banking, Genpact, TCS,
Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx
Teradata 
