sql - Symmetricds Transform Single Table to Multiple Tables Example -


please provide example configuration of transformation of single table multiple tables

practical scenario: have corp node , store node. have 2 tables customers , imp_customers in corp node, have 1 table customers in store node.

i have transform customers node in store customers , imp_customers in cloud node. please give example configuration of above transform in symmetricds 3.5 using sym_transfrom_table , sym_transform_column.

to transform single table multiple tables,
step 1:- first setup trigger table , link router (please ignore if have triggers)
step 2:- create row in sym_transform_table, specify direction of data, when perform transform, , tables involved.

 insert sym_transform_table(transform_id, source_node_group_id,      target_node_group_id, transform_point, source_table_name, target_table_name,     delete_action, column_policy) values      ('customers_to_imp_customers', 'store', 'corp',     'extract','customers', 'imp_customers', 'none', 'specified'),     ('customers_to_customers', 'store', 'corp',     'extract','customers', 'customers', 'none', 'implied'); 

step 3:- create rows in sym_tramsform_column, specify columns want transform , type of transform

insert sym_transform_column (transform_id, include_on, source_column_name, target_column_name, pk, transform_type) values ('customers_to_imp_customers', '*', 'id', 'id', 1, 'copy'), ('customers_to_imp_customers', '*', 'name', 'customer_name', 1, 'copy'), ('customers_to_customers', '*', 'id', 'id', 0, 'copy'); 

Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -