Full load with huge volume of records

[former_member647639]

I want to load huge volume of data from table A to table B. Load type will be always full load. How to lock the user when truncating old data from target table B and loading new into it.

If user want to retrieve the data in between the job processing time, count of target table should be shown previous records only.

Is there any option in BODS for lock or commit the database in job processing time?

I want user to show the data after full load will complete. If a user query in between, they should see the old previous records.

Thanks,

[former_member442248]

Not sure which database you are using but for certain databases you can build a materialized view on top of the table. Refresh MV only when table load is complete. Now for different databases MV comes with different options. You will have to go through the documentation and explore that.

Regards.

Shaz