t sql - Importing an exisitng BI solution to my own BI solution. How to go about it? - Stack Overflow

admin管理员组

文章数量:1123861

I get data from an external BI solution, it's a running star schema scenario. All the tables in the external are truncated every night. It mostly means new IDs in the tables.

My solution is a copy of the external solution but with the difference that I don't want to truncate my tables. I want to keep track of inserts, updates. I do have code for all that.

Each dimension table has a field called Code that identifies each row. I've been able to create my dimensions with inserts and updates and that is giving my own ID for each row, I can't use the external ID because they truncate.

Now I'm stuck on the Fact table. I get the fact table with their id for all the dimensions. Each row in the fact table has an ID. How do I convert this fact table to use my own ID from my dimensions?

There are also bridge tables many to many relationship. There is a ID field from the fact table and an ID from a dimension. It's their ID's I want to use my own that I created in my dimension tables.

I know this is a lot to take in and I don't know how to show this in code or with something else. Please respond if you need something more you need from me to solve this.

Thanks in advance

本文标签： t sqlImporting an exisitng BI solution to my own BI solution How to go about itStack Overflow