It almost qualifies as a Frequently Asked Question in demonstrations:
How do you handle persistent staging?
Persistent Staging is typically used to keep data from source systems in its original state.
One common reason for doing this is to have a full set of source system data available to support future changes that you may wish to make to star schemas. Having the data already in the data warehouse makes it simple to recreate or modify the star schema at will.
There are two types of persistent staging supported by Ajilius:
Read the tutorial to discover exactly how they work.