3 Replies Latest reply: Jul 17, 2012 11:57 PM by Rama Shankar RSS

Difference between Load and Replicate data in SLT

Shak N
Currently Being Moderated



Can any one say what is the differences between load and replicate data in SLT - HANA. Please could you also explain me the advantage and dis advantage on load and replicate data.




  • Re: Difference between Load and Replicate data in SLT
    Sathish Hariharan
    Currently Being Moderated

    Hi Shakthi,


    'Load' will load only the current data and not any other data that is changed afterwards (no delta support)


    'Replicate' will load the data till the current state and also all the changes that happen then on  (Replicate = Load + Delta).


    Load is advantage if you think you won't have any updates in any table and this will not create any triggers or logging table in the source system which are primarily required for delta (and hence replicate creates and uses them!)


    Replicate is advantage if you want real-time data always in HANA and which would enable you for real-time reporting.




  • Re: Difference between Load and Replicate data in SLT
    Kulwinder Singh
    Currently Being Moderated

    Hi Shakthi,


    Load - if i relate load into BW terms , then load is basically your first full load. You can choose load option for that purpose.It will bring your entire data structure and data into your HANA database.

    Usually load , we prefer when user doesnt want to see real time scenario, & if i think from developer point of view , i will prefer load , if i want to do modelling n my HANA studio, because i knw that data present with me will be correct , the possiblity of any error in real time entering of data by user will be avoided.once the model is ready , u can put the tables in replication mode......


    "Replication mode" - replication mode is used when user wants to see its data real time , in simple terms , replication will put triggers in ur source system and change log table in ur SLT system. As , the entry is created in your source system the triggers will automatically put values in your change log table & delta will pickup those enteries from changelog table into HANA database. this is hw ur replication works , in which you can see near real time data flow.



    My preference will be .... load table first ..... & then put it in replicate mode , if needed acc. to business scenario.....


    Hope this helps...




  • Re: Difference between Load and Replicate data in SLT
    Rama Shankar
    Currently Being Moderated



    In short, if you are familiar with how SAP BW delta data extraction works then - the SLT load is similar to init load in BW and SLT replicate is similar to delta loads in BW. SLT internally maintains delta mechanism.



    Hope this helps.