Answer Posted / santhosh
Fantrap means one-to-many joins of the tables it is
detected by visval analysis. By using fantrap problem is
many rows than expected. Through aliases,context and check
mutiple sql statements for each measures option we can
solve this problem.
chasm trap means two or more many to one joins converge on
to a single lookup table
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
In banking domain how many Fact tables,Dimension table are present?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what task is 98% of the required work of a business analyst?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what are the day to day activities of BO administrator ?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain about a time when you discovered a more efficient way to do a work task?
explain in detail about type 3?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain in detail about type 2(scd),
Which versions are used in the bo dashboard work?
What three things do you consider to be the most important factors for a manager?