53 What is the difference between full load and incremental load

preview_player
Показать описание
What is the difference between full load and incremental load
Download the file\script used in the Video from below link

What is the difference between full load and incremental load
What is an incremental load?
What is difference between initial load and full load?
What is the difference between full load and delta load?
What are the advantages and disadvantages of full load ETL and incremental load ETL?

Happy Learning.

Рекомендации по теме
Комментарии
Автор

i need to do a table with data modifications for a full load, do you have any video about that?

Ikerrodri
Автор

Hi Aqil, I am loading the data to warehouse and I also want to keep the old recored too, what can I do. Means I dont want to update, I just want to insert the data,

vinodclimes
Автор

Hi Aqil, Thank you for video!!
I have 2 records in a same file/table which has same values except salary.
First record has salary 10000 at 2 row and second record has salary 20000 at 10 row position.
As it's new record first time it will gets INSERTED but will it be get UPDATED when second record comes with change in salary i.e. 20000
Will it refresh cache and fetch record which was just newly inserted into table?

deepakj
Автор

Hi Aqil, I have a table and it has 3 columns like ID, Name, Salary now need 1 same salary column asc order and 1 more same Salary column desc order, how to write a query using MS sql

prajaakeeyaparty
Автор

While using lookup for 100million data with full cache its getting memory out error what is best solution for that??

BengaloruMachi