Page History

...

1. Identify the source reference or transactional data that will constitute the Data Store Object. If the data is sourced from multiple tables ascertain if a join between the source tables is possible, or if one or more intermediate-stage (work) tables would be a better option.
2. Using the 'drag and drop' functionality drag the load or stage table that is the primary source of information for the Data Store Object into a Data Store target. Refer to Building a Data Store Object for  for details.
3. If there's only one source table and all of the columns from it are being used, you can select the auto-create option to build and load the table. This automatically completes the next four steps. Refer to Building a Data Store Object for  for details..
4. Add columns from other Load and/or Stage tables if required. Refer to Building a Data Store Object for details.
5. Create the Data Store Object in the database. Refer to Building a Data Store Object for  for details.
6. Build the update procedure. Refer to Generating the Data Store Update Procedure.
7. Run the update procedure and analyze the results.

...