Page History

...

1. Identify the source transactional data that will ultimately constitute the fact or EDW 3NF table. If the data is sourced from multiple tables ascertain if a join between the source tables is possible, or if a series of passes will be required to populate the stage table. If the latter option is chosen, then bespoke code is needed.
2. Using the 'drag and drop' functionality drag the table with the lowest granular data into a stage target. Refer to Building the Stage Table for details.
3. Add columns from other source tables. Refer to Building the Stage Table for details.
4. Add any relevant dimension table or EDW 3NF table keys. Refer to Building the Stage Table for details.
5. Create the stage table in the database. Refer to Building the Stage Table for details.
6. Build the update procedure. Refer to Generating the Staging Update Procedure for details.
7. Test the update procedure and analyze the results. Refer to Tuning the Staging Update Process for details.
8. Modify the update procedure as required. Refer to Tuning the Staging Update Process for details.
   
   

   Note
   If you are building a Data Vault system, a Stage table with a type of Data Vault Stage can be created to generate hash keys that are used in building Data Vault objects (Hub, Link or Satellite tables). Refer to Data Vaults for details.