There is this conversion and aggregation

josna7733

Handling during transportation In the process of data synchronization, does it need to be processed Although data synchronization is often compared with **ETL (extract, transform, load) but in fact it is It is debatable that conversion is not required during synchronization. One to one synchronization The purpose of synchronizing data is to preserve the data history of the business. If you want to preserve the history, then the history of errors is also history. Therefore, this kind of synchronization is completely onetoone synchronization with the business system data,


even if the synchronized data is abnormal or nonstandard. Only in this Austria WhatsApp Number way can the business history be truly preserved, and when data anomalies occur and data is traced, the original business data can be found. Personally, I think this is a good idea, as it can completely retain business historical data. But there is a problem wrong data business systems can be changed at any time. However, synchronization in offline scenarios will not be performed at any time. And I feel that this is too extreme, and the requirements for personnel and procedures are relatively high. Conversion cleaning during synchronization The second kind of requirements are obviously not so strict and are relatively loose. Rowlevel additions, subtractions, and normalization





can be performed during this process. You can also perform operations such as field aggregation, association, conversion, etc. In fact, for product design, if this form is supported, onetoone synchronization is supported.  capability during the synchronization process. If not used, it will be onetoone synchronization. In this way, onetoone synchronization seems to be more of a norm and a requirement. Target table type for transfer The goal of moving business data to the data platform is to preserve history and make data traceable. However, the data of the business system changes all the time, so how to retain the history of the changed data is a problem of creating the target table structure.