6

Pass underlying table DW_SourceCode thru View

I loaded some records from a view which obviously is built off of a table. When I looked at the records in the destination table, the DW_SourceCode field had the value 'View'. I was expecting the underlying DW_SourceCode field from the source table.
Response from TX: The current behavior of custom views is to simply populate the destination table DW_SourceCode with the value "View." Unfortunately, you can't map any field onto DW_SourceCode in the destination table, but you can add it as an additional custom field.

This feature would be nice for tracking and being able to query the underlying source dataset.

1 comment

Please sign in to leave a comment.