Foundation: Understanding Projects

Projects form the foundation of metadata-driven data warehouse development, serving as containers for all data sources, transformations, and deployment configurations. They typically represent an organization's entire data warehouse, though additional projects can be created for prototyping or training.

Key features include:

  • Automatic versioning: Projects save incremental changes as distinct versions, allowing developers to roll back to previous states or compare versions side-by-side using multiple TimeXtender instances.
  • Project versions: When you open a project, the default version is always the latest saved version, though prior versions remain accessible for troubleshooting or iterative development.
  • Portability: Projects are exportable/importable via metadata, ensuring consistency across development, testing, and production environments.

Tips:

  • Save Often: Saves do happen automatically during Deployment. However, if you've made many changes without deploying, it's a good practice to save frequently to ensure you don't lose your work.
  • Version Notes: Writing in brief notes during every save is a great habit to get into as it can help you identify the correct version to look for if you need to investigate a change or roll back later on.
  • Compare Project Versions: open another instance of TimeXtender and load another version to view side-by-side. This enables easy development, testing, debugging, and prototyping with confidence and transparency.


For more detailed information, please see Projects.

Next