Agenda

✔ ETL Structure: Loading facts and dimensions, setting up staging tables, executing multiple ETL packages, and using templates 

✔ Debugging & Troubleshooting: Examples of common problems and solutions  

✔ ETL Scripts: Script samples, including the use of macros  

✔ Schemas: Snowflake schema vs. Star schema  

✔ Date & Time: Best practices and advanced settings  

✔ Export Formats: CSV and Excel best practices  

✔ Special Features: Currency, translations, and closing balance 

✔ Data Uploads: Incremental load in near real-time

Audience: Users interested in making data models for report designers

Prerequisites: Access to TARGIT Management is required to use these tips

You'll Hear From

Niels Thomsen

Niels Thomsen

Solution Architect

Jesper da Silva Endelt

Jesper da Silva Endelt

Senior Solution Architect

Want to Ensure Your InMemory Database Is Set Up for Success?

Your InMemory database serves as the foundation for data modeling and analyses inside of TARGIT.  

Learn more about setting up your database in part one of this webinar series, TARGIT InMemory ETL: Basic Tips & Tricks.