How do I divide the data in one source table among two or more target tables?
You can divide data into a column-level partitioning that allows the distribution from a single source table to two or more tables. This is desirable whenever you want to separate data for reasons of security or performance, for example, human resources information that not every one can see.
In some cases, you need to distribute only portions of a sending table to a receiving table or distribute some columns to one receiving table and other columns to another receiving table. Column-level partitioning allows you to decide where to distribute each sending table column.
-
Column-level partitioning is available for both replication and copy,
-
Use column-level partitioning with data transformation and gate conditions, either uni- or bi-directionally.
-
The sending table can be partitioned into those columns that are distributed and those that are not.
-
The receiving tables have in common many columns and their Distribution Key but have distinct values of the Distribution Key.
-
The columns to be distributed can be partitioned by receiving table, some columns routed to some receiving tables and not to others.
-
The receiving tables may be on the same or different receiving servers.