Table_Comparison using wrong compare table with System Configuration

[sapuserapr2021]

I am using a system configuration to select which schema my source and target tables come from. In one dataflow, I am using a Table_Comparison transform to detect differences in a table. The table I want to compare with is the same table that is my target. In the case of the target table, the system configuration determines which schema the table is in. Here is what my target table looks like in the dataflow:

At runtime, the schema of the table (either PDMLEWDBA or ORNEWDBA) is determined by the system configuration.

My problem is that in the Table_Comparison transform, when I select the table to compare with, I navigate to my data store and select the table and in the popup window where I select the table, the name in parentheses after the name of the table has the datastore name followed by a dot and then the schema name the table was imported under. My hope was that this schema would be selected at runtime by the system configuration but that does not appear to be what is happening. Here is the popup window where I select the compare table:

Notice the value in the parentheses after the table name, EDW_Target.PDMLEWDBA. When this value is used in my target table, the system configuration determines the actual schema used at runtime which in my case is either PDMLEWDBA or ORNEWDBA depending on which environment I'm in.

Below is the name of the compare table in the Table_Comparison table after I OK the form above:

Notice that the table name is EDW_Target.PDMLEWDBA.CONTAINERTEAM_STG. At runtime it specifically uses the PDMLEWDBA schema to compare to. This is OK when I am running in the PDMLEWDBA environment but when I am running in the ORNEWDBA environment (as determined by the system configuration) it is still comparing to the PDMLEWDBA copy of the table.

So, can I have the system configuration determine the schema of the compare table or am I stuck with having to use the schema that was used to import the table?

Thanks, Dave

[RichS]

I frequently do this (use table comparison with multiple system configurations) and it works fine for me. I would suspect you have a disconnect between your datastore configurations and your system configurations and it's using your default configuration somehow.

Can you double-check your datastore (right-click->edit->Advanced>>->Edit...) to ensure you have the proper settings for each of your configurations? Then, double-check your system configurations (Tools->System Configurations...) to make sure the datastore has the proper selections for each configuration?

[sapuserapr2021]

Thanks Rich, I'll take a look and report back.