Post

#dataBS I have a terminology question: I’m extracting more than one instance of a table from a single source (e.g., ERP customers). Same source db, same table definition, different data as they’re for separate entities. 1/2

ETL 😀 I jest, but I don't think there is a special name for merging data into a single file

I’d call the splitting “partitioning” and the readable object a partitioned view.

I wasn’t very clear in my wording - this is multiple physical source tables (one per business entity). I’m extracting each table to a separate file. All instances of a given table (entity1.customer, entity2.customer, etc) have the same columns, and I’m exposing them all using one DW external table.

The ext table presents the same result (plus some metadata) as if you’d unioned all the source tables.