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
41
Views
6
Comments
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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.