Answer Posted / prasanna.ramesh1
when there is one-to-many jointo a table that "fans out"
into another "one- to-many" join to another table.this
problem is called fan trap.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
can anybody tell me about complicated object you have created
What is aggregate table and aggregate fact table ... Any examples of both?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Give some information on report bursting?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is package in BO
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?
What Is The Difference Between Oltp And Olap?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to schedule the report in b.o?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
what is the difference b/w the refresh and buffered data?
