When data is being brought into Information Centric Analytics (ICA) through the Integration Wizard, what is the process for bringing data in from the source system into the ICA LDW tables?
SQL Server
When data is being brought into the ICA Database it will move from the base tables in the source system to the ICA Staging area. Once the data goes into the staging area, it will move to the ICA pre-processing area where formulas are applied, and other lookups are performed. The data is then moved into pre-processing via intra-day processing or through nightly processing depending on the configuration of the integration. After the data goes into the pre-processing area the data will be moved from the pre-processing area into the LDW area where it will remain at rest.