Best Practices, How-To

Description

Share your tips and best practices here

Difference between Land and Stage

Submitted by foxknight on

Land is an exact replica of source object. Land object doesn't contain control information such as STG_ID, ACTIVE_FLG, etc. as the history is not maintained and kept in land table. 

Stage contains entire data from source along with the change data captured over the period of time. Due to the nature of stage object behavior, additional control information is automatically added to stage object to identify and distinguish data at any point in time.