Skip to main content
To homepage To homepage
SUBMITTED

Mapping between tables in the Data Area

Related products:TimeXtender Data Integration
  • February 26, 2026
  • 1 reply
  • 18 views
E
Starter
Forum|alt.badge.img

In our DSA (a single Data Area per source) we use several tables for the same data set to make transformations in steps.

Each data set has at least two tables in the data area. The first we call Ingest-somthing wich is raw data mapped from the Ingest-instance.

The second one is where we validate data. We do at least this before moving on to DW.

However, Mapping sets only seems to be able to map between Data Areas. As in Ingest > DataArea1 > DataArea2 > ect.

But i would like Mapping sets to be able to map to another table in the same Data area. 

As in my case Ingest > DataArea1.Table1 > DataArea1.Table2 > DataArea2

1 reply

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • rory.smith
  • TimeXtender Xpert
  • February 27, 2026

Hi,

if you are landing tables in Prepare and keeping a raw table and moving that to a second, that seems a bit wasteful as the raw data is stored in the _R table for non-Simple mode tables as well. You could simply store your Table2s in a separate Data Area I guess.

Terms and ConditionsAccessibility statement