Good Morning Community. I have a rather strange issue that I have never seen before, and I am hoping that someone else has. I am currently working in a standard 3 tier archetecture, loading everything from QVD's. We are working on Version 11.1 for Desktop. We are also working on a 64bit server with ample RAM and Processing power. Here is my issue.
I load a series of Tables (as QVD's) into an appliction just fine. I then go about the process of creating a Link Table model. We need the link table model becuase we often have several fact tables. Everything loads just fine, except that the Link Table keys won't join. I create table boxes to check the keying and I get a key for each entry in the link table, but the fields in the actual tables, don't join. I get results that look like this.
It should be noted here that here that we are building our LinkTable using Concatenate and Resident loads. As you can see above, Key|EncID is the KEy that is added to the LinkTable. It appears that the Keys are not associating correctly. I have also noted that if we try to do a Mapping Load, using a resident Load Statement, it doesn't link. The Keys just don't relate or Associate. Now, if we remove the link table, the Keys will link fine and everything works great. So, it is my belief that this issue lies somewhere with a resident load. This is the only thing I can think of becuase the Link Table and the Resident Mapping loads are not joining. Oh yeah, there are 3 of doing developement at this location, and none of us can get this link table to join, or use Resident Mapping loads.
I have gone through this application with a fine tooth comb, making sure my Keys are all named the same, I have used Number wrappers and LTrim/Rtrim to emilinate trailers. I have copied cell values to text files looking for hidden characters. I have gone through the permissions of the application to see if There is a weird special permission I missed. I have gone through the User and Document settings to see if I missed something there. We have even gone back to the source system and checked the Output for the data type in the Database and made sure that they are all the same.
Has anyone else seen anything like this? We have other customers that we use LinkTable models with and have never seen this before, in versions before 11.1 and after 11.1.
Any help is appreciated.