Persisting table
Overview
Persisting table is a table type that stores the physical result of a transformation.
Function
Use this type when a transformation result must be materialized for reuse or performance. Selecting it is populated by a persisting definition.
When to use
Choose Persisting table when a transformation result must be materialized for reuse or performance.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Configure the source transformation, target table, package, and load options. |
| Processing | Persisting processing writes the transformation output into the physical table. |
| Output | The table provides a stored copy of the transformation result. |
Type-specific properties
| Property | Description |
|---|---|
| Transformation | Transformation that supplies the rows. |
| Target columns | Physical table structure receiving the output. |
| Package | Persisting package that executes the load. |
| Load behavior | Options controlling replacement, append, or related processing. |
Compatibility and limitations
The table structure must remain compatible with the transformation output.
Relationships
| Related entity | Relationship |
|---|---|
| Table | The table type defines the purpose and behavior of the table entity. |
| Schema | The schema type and warehouse architecture influence which table types are normally used. |
| Package | Import, historization, and persisting packages can populate specific table types. |
