In this exercise, you want to distribute only some columns from a corporate automobile insurance to your divisions from source table DVCOLE.VEHICLES to target tables dvcole.cars and dvcole.policy.
It is assumed that:
-
The source host and server are defined.
-
The target hosts and servers are defined
-
Distribution tables are in the available cache for the source and for the target.
-
Source and corresponding target servers are defined