ETL

ETL

The ETL menu contains development assets for extraction, transformation, and loading. Group work into packages, write scripts, manage imports, and handle historization scenarios with reusable transformations and generated dimensions.

Icon	Feature	Description
	Packages	List ETL packages that group transformations and workflows.
	Scripts	Contain SQL or script-based transformations for ETL.
	Imports	Manage import processes from external sources into the warehouse.
	Historizations	Handle slowly changing dimensions and historical data tracking.
	Transformations	Define transformation logic for staging and warehouse layers.
	Transform.	Launch Transformation Wizard
	Calendar Dimension	Generates a reusable calendar dimension (year, month, day, etc.).
	Time Dimension	Creates a detailed time dimension (hours, minutes, seconds).
	Snapshot Dimension	Creates snapshot dimensions to capture point-in-time records.