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 :
• ETL Testing
SQL Tutorial for begginers and advanced level :
• SQL Tutorial for Begin...
Linux Tutorial for beginners and advanced level:
• Linux for Testers
Data Warehousing Tutorial for beginners and advanced level:
• Data Warehousing concepts
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.

[@jitendraurkude6152]

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

[@FarhanaShamnad-h1b]

Thanks for the video. Can you pls explain what is delta load?

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

[@amitkatkar8286]

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

[@amitkatkar8286]

@@etlqalabs5048 thank you very much sir