We have fields defined in our connector that are not mapped to a dimension or attribute. I need to build a data adapter to take data from StageSourceData and tie it to the table that holds the data brought in by the adapter so I can grab one of these fields that is not mapped (Location). Can someone advise what is the table name that holds the raw data brought into OneStream by the adaptor (before it is mapped to a dimension or field)? Thanks!
The unmapped fields/data records are stored in the StageTargetData table. However, it is recommended to use the vStageSourceAndTargetDataWithAttributes and vStageSourceAndTargetData views. All unmapped data records will have a ~ in the columns where the column headers end with T for Target