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!

Data modeling question

729299Jan 22 2010 — edited Jan 26 2010
Hello Experts!

I have always wondered if you can actually change ROW_WID to VARCHAR and eliminate the dependency on it by making use of INTEGRATION_ID in your datawarehouse when you are having only a single course to get data from. Is there any particular reason why ROW_WID needs to of type NUMBER (and not VARCHAR) and why we cannot simply use INTEGRATION_ID as your primary key in single source scenarios?

Thanks for your time!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2010
Added on Jan 22 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
3 comments
861 views