8. [Snapshot Transformation Wizard](/Reference-guide/Snapshot-transformation-wizard)

The Wizards in AnalyticsCreator provide a guided and efficient way to perform various tasks related to building and managing a data warehouse. Below is an overview of the eight available wizards and their core functions. The DWH Wizard is designed to quickly create a semi-ready data warehouse. It is especially useful when the data source contains defined table relationships or manually maintained references. Key Features: - Supports multiple architectures: Classic (Kimball), Data Vault 1.0 & 2.0, or mixed. - Automatically creates imports, dimensions, facts, hubs, satellites, and links. - Customizable field naming, calendar dimensions, and SAP DeltaQ integration. The Source Wizard adds new data sources to the repository. Key Features: - Supports source types: Table or Query. - Retrieves table relationships and SAP-specific metadata. - Allows query testing and schema/table filtering. The Import Wizard defines and manages the import of external data into the warehouse. Key Features: - Configures source, target schema, table name, and SSIS package. - Allows additional attributes and parameters. The Historization Wizard manages how tables or transformations are historized. Key Features: - Supports SCD types: 0, 1, and 2. - Configures empty record behavior and Vault ID usage. - Supports SSIS-based or stored procedure historization. The Transformation Wizard creates and manages data transformations. Key Features: - Supports Regular, Manual, Script, and External transformation types. - Handles both historicized and non-historicized data. - Configures joins, fields, persistence, and metadata settings. The Calendar Transformation Wizard creates calendar transformations used in reporting and time-based models. Key Features: - Configures schema, name, start/end dates, and date-to-ID macros. - Assigns transformations to specific data mart stars. The Time Transformation Wizard creates time dimensions to support time-based analytics. Key Features: - Configures schema, name, time period, and time-to-ID macros. - Assigns transformations to specific data mart stars. The Snapshot Transformation Wizard creates snapshot dimensions for snapshot-based analysis. Key Features: - Allows creation of one snapshot dimension per data warehouse. - Configures schema, name, and data mart star assignment. By using these eight wizards, AnalyticsCreator simplifies complex tasks, ensures consistency, and accelerates the creation and management of enterprise data warehouse solutions. ⬅ Previous Page | ➡ Next Page