Create a bridge table? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Create a bridge table?

Received Response
42
Views
6
Comments
Chris Arnold
Chris Arnold Rank 5 - Community Champion

They say there is no such thing as a 'dumb question'...so here goes...

Currently, we are using 11g (but will be upgrading to 12c in approximately 1 month)

In my RPD I need to join a fact to a dimension with a many-to-many relationship.

All of my internet searching seems to point me toward the use of a bridge table for this. While I do not totally understand the concept of bridge tables and how to implement them, I figure I can try to figure it out as I go -- sort of learn from the 'hands-on' experience.

Here is where my problem is -- I don't really know where to begin. Every blog and post I see talks about modeling the bridge table, but I can't find anything that actually talks about CREATING the bridge table.

So my questions are...

(1) Can I create the bridge table in the RPD, or is the bridge table created in the database and then I import it into the RPD?

(2) If the bridge table gets created in the RPD, where might I see some instructions on how to do this? (not just the modelling, but also the creation)

Any help is much appreciated.

Answers