After completing the transformation task data loading activity-00456
This subjective question is related to the book/course
vu cs301 Data Structures.
It can also be found in
vu cs301 Mid Term Solved Past Paper No. 3.
Question 1: After completing the transformation task, data loading activity is started. How many types of data loading strategies are and when each type of strategy is adopted explain.
" Full data refresh with BLOCK INSERT or "block slamming into empty table.
" Incremental data refresh with BLOCK INSERT or "block slamming into existing (populated) tables. " Trickle/continuous feed with constant data collection and loading using row level insert and update operations.
Answer:
Once we have transformed data, there are three primary loading strategies:" Full data refresh with BLOCK INSERT or "block slamming into empty table.
" Incremental data refresh with BLOCK INSERT or "block slamming into existing (populated) tables. " Trickle/continuous feed with constant data collection and loading using row level insert and update operations.
