I have a dimension with a parent-child relation and a package that can be configured to clear all the data in the table used as a source for the dimension and load data into it from another database. The problem is that I get a "The INSERT statement
conflicted with the FOREIGN KEY SAME TABLE constraint" error message. My assumption is that it happens due to some child rows being inserted to the table before their related parent rows. How can I handle such a situation? The inferred members option
in the slowly changing dimension component is only for values in fact tables that have not yet been loaded to the respective dimension tables.
View Complete Post