Ok. It is not the Primary Key that is the issue. I have five tables, three of which are loading properly. They have primary keys.

I was working with a NOETIX 5.6 on-premise system. My new employers are asking for some input into their BI path forward. My experience with NOETIX was problematic, at best. It is an amazing tool, but it comes with significant costs. It is complex, requires a well seasoned administrator, uses a lot of storage, is highly…

Thanks to both, I could have marked either as a "correct" answer, but it only allows one. Both sets of comments were very useful. Rob

GC, This was very helpful. Next round of questions, if time permits. This time, I want to focus a little on how to start-from-scratch. As a first step, I want to eliminate NOETIX as my ETL engine and data model for this discussion. So, as I see it, from your comments there are two basic approaches. First, we could use…