In part two of our InMemory webinar series, attendees will learn how to go beyond ad-hoc projects and level up their InMemory database skills alongside Solution Architects Niels Thomsen and Jesper da Silva Endelt.
Find out how to implement an ETL framework that includes templates, macros, a staging area, and best practices for data modeling. Then, explore special functions like currency handling, translations, closing balance calculations, and more.
✔ 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
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.