Hi Skarai, it's just based on my experience, not based on math. A table which contains 1000 to 5000 records (say 10 to 100 columns) on 100M LAN normally takes 1...

Hi Robert, thank you for your comments.

The ODS is not a data warehouse because ODS is in the third normal form, not in dimensional model. But yes you are right,...

We populate the stage of our data warehouse with 3 different methods:

1. Rebuild - we clear the stage everytime and download the entire table (all records) from the source...