TimeXtender element61 Best Practices

Course description and Duration

During our history of implementing TimeXtender projects, we’ve build a set of best practices.
In this 1 day training we’ll be covering these guidelines and show how to implement them in your TimeXtender projects.  Next to the best practices we’ll also cover some more advanced features of TimeXtender.

Learning outcomes

  • Introduction
  • Best Practices on
    • Naming Conventions
    • Project setup / template
    • Database connection setup (filesize, growth, time-outs, connection-string)
    • Incremental load options / trigger full loads
    • Transformations
    • Conditional lookups
    • Surrogate Key handling
    • Dummy Records creation
    • Semantic model setup / Tabular Model optimizations
    • Project perspectives / Dynamic perspectives
    • Security setup
    • Execution packages
    • ODX Server / Data Selection Rules (Data Staging Area)
  • Advanced TimeXtender features
    • Target based incremental (marked as deprecated feature but still very useful)
    • Multiple field based conditional lookups
    • Aggregate Tables
    • Table Inserts
    • Add Related records
    • Project variables
    • Use of the REST API