I am having some confusion as to how to decide what to choose between Data Consolidation/Data Integration and Data Synchronisation? I know that:Data Consolidation/Data Integration: refers to the collection and integration of data from multiple sources into a single destination. During this process, different data sources are put together, or consolidated, into a single data store.Data Synchronisation: refers to establishing consistency among systems and data stores and subsequent continuous updates to maintain consistency.Now suppose I have a case like this regarding a company:- Data is present in multiple sources often department wise- Because of this majority of time company spends in validating data rather than on useful analysis for planning- The data definition also varies between different sourcesNow given such a case which is better to use - Data integration/consolidation or leaving the data in different sources and synchronize it?Also what other useful and relevant information should I look for that may help in making the decision and how those additional information will reflect on my decision making?
How and when to choose between Data Consolidation/Data Integration and Data Synchronisation?
database;data;freelancing;integration;data warehouse