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
Post a Comment