The different replication scenarios are Load, Replicate, Stop, Suspend and Resume.

Before any application table is selected, the initial load of the tables DD02L, DD02T & DD08L must be completed as they contain the metadata information.

Load: This starts an initial load of replication data from the source system. The complete procedure is a one-time event. Once completed, further changes to the source system database will not be replicated. Also for the initial load procedure, neither database triggers nor logging tables are created in the source system. The default settings use reading type 3 (DB_SETGET) with up to 3 background jobs in parallel to load tables in parallel or subsequently into the HANA system.

Replicate: This combines an initial load procedure and the subsequent replication procedure (real time or SAP HANA INTERVIEW QUESTIONS 4 scheduled). Before the start of initial load procedure, trigger of database and related logging table are created for each table in the source system as well as in SLT replication server.

Stop Replication: This stops any current load or replication process of a table. The stop function removes the database trigger and related logging tables completely. This function is used only if you want to continue a selected table otherwise it must be initially loaded again to ensure data consistency.

Suspend: This pauses a table from a running replication. Also the database trigger will not be deleted from the source system. The recording of changes would continue and the related information would be stored in the related logging tables in the source system. If tables are suspended for a long time the size of logging tables may increase and adjust the table space if required.

Resume: This restarts the application for a suspended table. The previous suspended replication will be resumed (no new initial load required).

Related questions