Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fact table

887682Sep 12 2011 — edited Sep 13 2011
Hi Experts,

1.I have a question like for better performance should we use two fact tables or one fact table? ( I have two fact tables but let me know if i should use only one fact table by joining the other
Logical table source)

2. I have a detailed report to show with million records what should i do for the better performance.

PS: This report is detailed so there is nothing to Aggregate.( I am using 10.3.4.1 version)

Thanks in Advance.

chak.

Edited by: 884679 on Sep 12, 2011 9:20 AM

Edited by: 884679 on Sep 12, 2011 9:21 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2011
Added on Sep 12 2011
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
14 comments
187 views