Skip to main content
To homepage To homepage
  • Source1
120 Topics

What is TimeXtender? - course module

Learn the key concepts, native features, customer use cases, and reference architectures that TimeXtender provides for future-proof, and holistic data solutions.

Use Schemas (e.g. ETL, DBO) to separate Valid tables in Data Warehouse

Learn how to use this technique of separating Valid tables in the Data Warehouse, by using schemas. This is especially r3levant when using a single SQL DB for the Data Warehouse storage, and improves performance by limiting the cross-database data transfers.

Schema Behavior

Learn about the different types of Schema Behavior, such as 'Main Default schema', 'Main Raw schema', and 'Main Valid schema'. By using these different types of schemas, you can limit the tables that are not necessarily used for reporting.

Add Customized Code to Table

Learn how to add customized code to a table. WARNING: this is an advanced feature, and can have uninteded consequences if not configured or applied properly. Please contact your partner or Solution Specialist before using this feature for guidance!

Add Custom View as Table Insert

Learn how to use a SQL Custom View as a Table Insert

User-Defined Functions (UDF)

Learn how to create and execute User-Defined Functions (UDF), using SQL in TimeXtender.

Stored Procedures (SP)

Learn how to create and execute Stored Procedures (SP), using SQL in TimeXtender.

Custom Data, manually entered or imported from Excel

Learn how to manually add custom, static data directly within the Desktop, or importing it from Excel. This can be really helpful when working with specific variables, values, or other small data sets to be used in transformations, validations, and more.

SQL Snippets

Learn how to create, manage, and apply custom SQL code snippets. This feature can be used with Field-level transformations, Views, Stored Procedures (SP), User-Defined Functions (UDF), and Script Actions.

Add Related Records & Handling Early Arriving Facts (EAF)

Learn how to handle Early Arriving Facts (EAF) by using the 'Add Related Records' feature in TimeXtender. This feature can be particularly useful when working with disconnected business processes and natural delays in inter-departmental workflows.

Table Inserts

Learn how to insert data from one table into another, and creat SQL unions with Table Inserts.

Aggregate Tables

Learn about Aggregate tables, and how to quickly build tables that summarize and aggregate data (e.g. MIN, MAX, SUM, AVG, COUNT, and more).

Table Transformations - course module

Understand table transformations with schema management, stream-lined data aggregation, practical SQL snippets, and seamless custom data and code integration.

Enable SCD: Type 1 & 2 (example - Customer name & email) - MDW

Learn how to select the fields to be treated as Slowly Changing Dimensions (SCD), for Types 1 and 2. This is the second step to enable SCD in TimeXtender, after enabling History and selecting a 'Natural Key'.

Enable History & Natural Key (example - Customer dimension table) - MDW

Learn how to enable History settings on a table, and also to select a 'Natural Key'. This is the first set to enable Slowly Changing Dimensions (SCD) in TimeXtender.

History & Types of Slowly Changing Dimensions (SCD) - MDW

Learn how to implement History settings on a table, and to understand the different types of Slowly Changing Dimensions (SCD), such as Type 0, Type 1, and Type 2.

What are Slowly Changing Dimensions (SCD)? - (example - customer address changes) - MDW

Learn the basic idea of Slowly Changing Dimensions (SCD), and an example of real-world use case: customer address changes.

Enable SCD Type 2 Dimensions (example - track Bonus and Commission Percentage)- MDW

Learn how to use SCD type 2 to track salespeoples' bonus and commission percentage, and how to configure the SCD Type 2 settings in TimeXtender.

Supernatural Keys (example - Product Key) - MDW

Learn about Supernatural Keys, and the 'Key Store' which leverages multiple hashing algorithms, and simplifying early-arriving facts (EAF) management.

Surrogate Keys & System Control Fields (example - 'DW_Id' as key) - MDW

Learn about Surrogate Keys, and how to create a surrogate key using a System Control Field ('DW_Id), to handle an SCD Type 2 use case (i.e. salesperson name).

Terms and ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings