Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ramesh
the fan trap is let we take 3 tables the 1 table is joined to
2 table with 1 : N Cordinality and 2 table is joined to 3 table with 1 : N cordinality
I.e 1.....(1:N)......2....(1:N).....3
then it it forming a fan trap.
it does through any errors but the the required data will not get corectly
so by using alias we can resolve this traps
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between condition & filter?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How were the reports scheduled and how to resolve unexecuted documents?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What is top business?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How to restrict password to a user while sending a document in .pdf format
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 are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is package in BO
8. How much supervision have you typically received in your previous job?
What is Indexing? how did u implement indexing?
Explain what task is 98% of the required work of a business analyst?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
what is the difference b/w the refresh and buffered data?
