Skip to main content
SUBMITTED

Be able to map or override DW_SourceCode in Aggregate Tables

Related products:TimeXtender Data Integration
  • February 27, 2023
  • 1 reply
  • 25 views

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8

Aggregate Tables will currently show “Aggregate” in the DW_SourceCode field. In some cases users will want to pass on the DW_SourceCode present in the original table or perhaps specify one of their own.

As system fields cannot be modified by transformations, changing this currently requires using a post-step or doing the aggregation in a Custom View or other feature.

Features like Table Insert already allow you to choose how to fill DW_SourceCode, having a uniform approach across features would be more consistent.

1 reply

devin.tiemens
TimeXtender Xpert
Forum|alt.badge.img+6
  • TimeXtender Xpert
  • February 27, 2023

Great idea, additionally it would be nice to have the option to change the short name in the data source connection in the ODX so that those DW_SourceCodes can also be changed. This is not possible at the moment.