Hi your videos are very helful and detailed, thanks for doing these :) ETL TESTING INTERVIEW Q's. please help solve 1. column in target blance_zero flag --> balnce is 0 y, >0 then N write a source query 2. table 1:customer(id,fname, lname, location, emailid) table 2: account(acctno,acctname,balance,branch,accttype,custId,balzero_flag) write a query to fetch number of customers who has savings acct branchwise...(id and custId are common field)
@kumarrajiv2821
2 ай бұрын
can make video on how to run etl job
@dastageerpinjar5065
3 ай бұрын
When started following your channel for DB related things Then only 500 to 600 subscribes year back but now family is increasing almost near 4k Congrats "Tester hoon"
@testerhoon28
3 ай бұрын
Thank you 🙏
@yashipandey4771
9 күн бұрын
Hi Ma'am, Please answer this interview question for me, How have you validated the ETL when you've hundreds of table to join? Have you used any tool?
@testerhoon28
6 күн бұрын
We need to use automation in that case
@MENTALFLOSSER
3 ай бұрын
How do you indentify and perform regression testing for the database ..what are the basis ..please do let me know .Thank you
@testerhoon28
3 ай бұрын
Okay 👍
@vaibhavrane9979
3 ай бұрын
Hello Mam, I have some questions. 1)how to test data if source (Oracle) and target(Sqlserver) are different databases? how we can connect them? 2) how to validate data flat file vs Table or Table vs flat file? 3) could you please make a practical video on parameter file which we use in the ETL project? why we use parameter file ? 4)could you please make a video on hadoop bigdata testing?
@testerhoon28
3 ай бұрын
Sure will make vdo on that
@AP-tn7yh
3 ай бұрын
How do you validate if source is in DB and target is flatfile
@testerhoon28
3 ай бұрын
Will cover this point in the next video 👍
@Pavan0235
3 ай бұрын
Hi madam,first of all thanks for videos. Q. Source is having less records than intermediate. In this case how to validate the records in intermediate is correct. Q. In 1st run source is having 10 records staging is having 10 and intermediate is loaded with same 10 records. Now in 2nd run (incremental) source is having 5 records (2 new, 3 updated records) so staging is having 5 and intermediate is having 10+2. How to validate 1st run records in intermediate as source and staging is truncated and having only 5
@testerhoon28
3 ай бұрын
Will cover all mentioned points in my next video 👍
Пікірлер: 15