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

[@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.

[@jitendraurkude6152]

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

[@ArifRaza]

Thanks a lot sir. Your videos are really very helpful

[@etlqalabs5048]

Thanks for your kind words Arif . Such feedbacks reenergize me for more insightful content.

[@MM-gq1vl]

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?

[@swapnalimisal3736]

How to validate scd type could you please explain Sir

[@etlqalabs5048]

Will try

[@komalishware]

helpfull

[@siddharthb2162]

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

[@etlqalabs5048]

@@siddharthb2162 please you can share your contact details over email "[e-mail]" . We will get back to you

[@Engineer_Amit_Katkar]

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?

[@sangeetsaga2618]

We can write 4-5 test cases and can validate all of them if there is no complex logic

[@etlqalabs5048]

1. To answer in interview you can say around 200 test cases given your project is off medium size project 2. There is no definite answer. It depends on your project and complexity of the features you are writing test case for . But you can say like 8 - 10 test cases for etl validation

[@Engineer_Amit_Katkar]

@@etlqalabs5048 thank you very much sir