Importing and updating data
Importing and updating data to a Data Store can be set up as part of the star schema configuration, or you can write custom SQL scripts to do the job. Updating data to a Data Store from within InVision is usually done by executing one or more Data Flows that performs the update logic defined by the star schema, or runs your custom SQL script.
Using the the data import / update part of the star schema configuration, you define properties for filtering data to import, transformations (pivot, unpivot, aggregate), conversions, calculations and data set compilation using the Core Set feature.