Column partitioning - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

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.