Database Build and Preparation

Definitions

• Definition Files
  • LoadDefinition
  • Metadata
  • Decodes
  • Banding

Data Preparation

• Data Sources
• RemoteFileManager

Loading

• CreateTableFromFile
• LoadTableFromFile
• UpdateTableFromFile
• CreateTableFromWorkbook
• Merging Data Sources
• ScriptEditor
• BulkLoading
• Sampling
• Data Source Configuration

Auditing and Inspection

• Data Audit Report
• Field Analyzer
• Inspection Reports
• API: Audit - Summary Report
• API: Audit - Penetration/Profile Report

Joins

• Joining data
• Join restrictions
• Join Layers
• Casting

Derived Data

• Rename
• Functions
• Expressions
• User Defined Functions
• Decode
• Banding
• Aggregates
• Bulk Processing

Merge, Append and Filter

• CopyUp
• CopyDown
• Appending Data
• UPSERT

Resolution Levels

• Resolution Levels
• Key Tables

Metadata

• Metadata Properties and Definition
• Configuring Metadata
• Attaching Metadata
• Auditing Metadata

Publishing

• CopySourceTable
• CreatePackage
• Injecting Data
• Controlling Data Visibility