Prepare¶

Prepare instances: transforming and modelling data in the data warehouse.

Articles by topic¶

Reference · Fields & keys¶

• Cloning a field
• Conditional Lookup Fields
• Custom Fields
• Custom Hash Fields
• Primary Keys
• Related Records
• Supernatural Keys
• Tagging a Field

Reference · Loading & history¶

• Incremental load in Prepare Instances
• Transfer data to a Prepare Instance
• Use History to implement Slowly Changing Dimensions

Reference · Security¶

• Data Area Security - Database Roles
• Data Area Security - Object Level Security
• Data Area Security - Row Level Security

Reference · Storage & performance¶

• Indexes
• Performance Recommendations
• Simple mode
• Spatial Joins with Timextender
• Storage Cleanup Tool

Reference · Tables & schemas¶

• Aggregate Table
• Custom Tables
• Date Table
• Junk Dimension Table
• Prepare Instance - Table Settings
• Prepare Instance Perspectives
• Reverse Data Area
• Schemas
• Set Distribution for Tables on Azure Synapse Analytics
• Table relations

Reference · Transformation & data quality¶

• Batch Data Cleansing
• Data Profiling
• Data Selection Rules
• Data Transformation
• Data Validation Rules

Reference · Views, code & parameters¶

• Custom Views
• Instance Variables
• Lookup Transformation Template
• Persist View
• Previewing Data
• SQL Snippets
• Stored Procedures and User Defined Functions
• Use Fabric Lakehouse for Prepare instance storage (Public Preview)
• Use Fabric Warehouse for Prepare instance storage (Public Preview)
• Use parameters in your scripts, views and calculations

How-to guides¶

• Add a Custom Table Insert
• Create a Role-Playing Dimension
• Customize code on Fabric Lakehouse
• Customized Code and Custom Scripting
• Enable Element Locking
• How to Identify and Prevent Circular References
• How to add a default value to a unique identifier field
• How to configure Table Partitioning
• How to copy tables/fields between data areas
• How to use Raw-only fields
• How to use Snippets to create resuable code
• Integrate existing objects
• Mapping set
• Remove Unused Objects from a Prepare instance
• Using Object Dependencies to explicitly set the table and view execution order in a Prepare Instance
• Using Work Items as part of Team Development

Concepts & overviews¶

• Guidelines for maintaining clustered SQL indexes on Incremental Load and History tables
• What is a Data Staging Area?