TX allows to add data selection rules over calculated fields but gets an error in execute

  • 21 February 2023
  • 6 replies
  • 47 views

Userlevel 4
Badge +1

As you can see in the screenshot, I think that this situation must be controled:

 


6 replies

Userlevel 2

How did you actually manage to select a field in your selection rule, that is not available in your mapped (source) table?

Userlevel 4
Badge +1

@RLB That’s the problem, TX allows that:

 

Userlevel 2

Very interesting! I believe the Data Selection Rules panel should only list the columns that have a mapping to the source table. In my TX environment that is actually what I'm seeing.

I'll be following this.

Userlevel 4
Badge +1

@RLB That screenshots are for the new version:

 

Userlevel 6
Badge +7

Even worse, if you implement such a Data Selection Rule on an incremental table that has already been loaded to DSA from ODX (ADLS) it may work until you run an explicit full load.

Userlevel 4
Badge +1

Definitely it’s an error that must be controled

Reply