@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

@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?

@komalishware

helpfull

@swapnalimisal3736

How to validate scd type could you please explain  Sir

@siddharthb2162

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

@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?