Importing Tables and Building the Staging Layer
Import Tables
- Choose your connector (e.g., SAP).
- Right-click to import tables (e.g., BKPF, BSEG).
- Assign a package name (logical grouping of imported objects).
Historization
- Tables can be historized to keep track of changes over time.
- Use snapshot or actual historization types:
- Snapshot: Keeps historical versions.
- Actual: Keeps only the current version.
Each historization table is stored in its own schema and can be reused in transformations.