TARGIT InMemory ETL:
Basic Tips & Tricks - Part Two

On-Demand Webinar

Discover New Ways to Use Your InMemory Database

Illustration - InMemory Advanced

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.

You'll Hear From

Niels Thomsen

Solution Architect

Jesper da Silva Endelt

Senior Solution Architect

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

Square - Webinar for dealers - TARGIT-3

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.

Watch On-Demand Now

Originally published February 9, 2023. Updated February 20, 2024

Unlock InMemory Tips and Tricks