Forum Discussion

cnpdx's avatar
cnpdx
Icon for Helper II rankHelper II
8 years ago

Error when creating a relationship

Hello, I am trying to create a relationship between all my tables using "account name unique" (which should be unique), and my other tables, such as "account name" in the opportunity table (it's a Z...
Need Help
lawsonbe's avatar
lawsonbe
Icon for Helper I rankHelper I
8 years ago

You probably should not have to do this but a last resort would be to add a unique ID column and just give a number. You would then have to use that record along with all the entries in your source tables. Again, a little bit of trouble now but it may save you some headaches later.

cnpdx's avatar
cnpdx
Icon for Helper II rankHelper II
8 years ago

If I make a unique ID, what am I matching it up to? Neither the fact or dim tables have a unique ID. So if I make a unique ID on the fact table, how does that help me relate records in the dim table?