When integrating WhereScape generated tables and views a number of additional considerations need to be taken.
The Dimension tables and views make use of secondary business key columns such as dss_source_system_key, dss_current_flag, dss_end_date, dss_version to assist in handling various forms of slowly changing dimensions and non conformance. These secondary business keys need to be flagged as such against the dimension.
Change the properties of all such columns. The key type should be set to 1, and the primary business key checkbox should be set.