ETL Testing : What is Full Load vs Incremental Load is ETL process

#etlqalabs #etl #sqlinterviewquestionsandanswers #linux

ETL Testing : What is Full Load vs Incremental Load is ETL process

Playlists for your reference:
ETL Testing Tutorial for begginers and advanced level :

SQL Tutorial for begginers and advanced level :

Linux Tutorial for beginners and advanced level:

Data Warehousing Tutorial for beginners and advanced level:

Hey Guys,
If you’re enjoying this video and you’d like to support this channel, please do to consider subscribe this channel! It might seem small, but hitting that subscribe button helps alot and means more contents in future.

[ArifRaza]

Now I completely understood the full and incremental load. Incremental actually consists of the SCD type 2 in case updated records are loaded in the data warehouse. It will persist both the original and updated records. Now we can easily perform ETL validation. We will select those updated records from the target based on the date and will select the same records from the source and we can check the data count match, data mismatch from source to target.

[ArifRaza]

Thanks a lot sir. Your videos are really very helpful

[jitendraurkude]

THANK YOU SIR FOR THIS VERY INFORMATIVE VIDEO IT IS VERY HELP US THANK YOU ONCE ANGAIN☺☺

[MM-gqvl]

Thank you Sir for your quick response and detailed explanation.
It would be of great help if you can help with below:
1)As you said incremental load may come daily but while testing in agile(biweekly sprint), do we test 2 weeks data because testing incremental load each day is not feasible.
2)In QA env, if we dont have access to ETL tool(SSIS) then how do we load our Testdata in QA staging in each sprint.Also, can we load our testdata along with incremental load data?

[swapnalimisal]

How to validate scd type could you please explain Sir

[amitkatkar]

Hello sir, i have some questions.

1-- How many ETL Test Cases we wirte in project?

2- How many ETL Test cases we wirte in one day and how many excute in one day?

[siddharthb]

sir please can you share your contact details. i want to discuss related to ETL training. i am currently working