Interested to Buy Any Domain ? << Click Here >> for more details...
When we r going for Short_cut join & It's Resolution???
Plz provide one scenario??
- 2 Answers
- 7393 Views
- Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / kishore babu
if we have 3 tables A,B,C. our requirement is A->B->C &A->C
That means we make three joins. the referential integrity says
joins must be no.of tables-1.so the join A->c join make as a
short cut join.more than 3 tables we dont go for short cut
join.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
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
how to create reports on screech?
Explain in detail about type 2(scd),
Explain when we use aggregate awareness function in designer?
what is document design in boxi,have u participate in that
what are the tables used in health care domain project and columns used in report?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
In banking domain how many Fact tables,Dimension table are present?
What is object stores?
