Course Description and Duration
During our history of implementing TimeXtender projects, we’ve built 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 a 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