Жыл бұрын
Жыл бұрын
Жыл бұрын
Пікірлер
@jayateja301 6 сағат бұрын
Can I have your email ID ,I need full training video on c# to automate ETL testing.
@rahulkhandare5767 5 күн бұрын
Nice❤
@PraveenKumar-il8kn 7 күн бұрын
HI Mam, Are you providing training for ETL testing.
@testerhoon28 6 күн бұрын
As of now I am not taking any classes
@6sharan 29 күн бұрын
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)
@yashipandey4771 Ай бұрын
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 Ай бұрын
We need to use automation in that case
@Nalinee01 Ай бұрын
Thank u for video....
@WonderWorks17 Ай бұрын
Hi mam.. I need your help regarding real-time experience in the ETL Testing job how can I connect with you if possible please share your LinkedIn profile or your email address
@testerhoon28 Ай бұрын
Email me @ [email protected]
@jamikrishna-eq5bl Ай бұрын
your voice is not cleared when given the answer of validation part.
@testerhoon28 Ай бұрын
Okay will improve the voice quality 👍
@venkata928 Ай бұрын
Thanks a lot for this video. But I cannot relate to the sql query results and the PBI visual values. Are you using the same dataset for both report and the query?
@testerhoon28 Ай бұрын
I have explained just to show case how to write an SQL query for such type of scenarios 👍
@venkata928 Ай бұрын
@@testerhoon28 Yes ofcourse. Many thanks for uploading the video and Helping me to understand how to perform report testing!
@ganeshcharipally 2 ай бұрын
Where we can download etl mapping document to practice informatica
@testerhoon28 2 ай бұрын
Email me I'll share with you
@jagan2823 2 ай бұрын
Mam when we will ADF testing concepts would be explained?
@testerhoon28 2 ай бұрын
Soon I will make a video on that..
@ashishkumar-on8xg 2 ай бұрын
Thankyou for this informative video, explained in very clear and simple way. Thanks
@testerhoon28 2 ай бұрын
😊👍
@537ASLAM 2 ай бұрын
Excelllent explanation... thanks sister
@testerhoon28 2 ай бұрын
😊
@kumarrajiv2821 3 ай бұрын
can make video on how to run etl job
@sravanworld9419 3 ай бұрын
I have experince in informatica power center is there any growth in informatica other wise i have to upgrade azure adf and databricks
@testerhoon28 3 ай бұрын
Better to upgrade ADF, ADB for growth
@STEAVEJOBS-kb3dx 3 ай бұрын
1.How can we do the data sampling if we used different source and target dabases? 2.what are the all etl testing we will do for the above example ?? (Etl testing process). 3.what is use of CI/CD pipeline?? How its usefull in etl testing??
@STEAVEJOBS-kb3dx 3 ай бұрын
Really helpful ❤
@Gowthami959 3 ай бұрын
If its in English means it would be more good for the people who doesn't understand Hindi
@testerhoon28 3 ай бұрын
Now I have started making videos in English...🙏
@riyavenkat2637 4 ай бұрын
Pls mak it in English r else try to give English caption
@testerhoon28 3 ай бұрын
Sure 👍
@RahulPawar-vl9to 4 ай бұрын
can we do automtion testing on this kindly reply me i want to discuss on this
@testerhoon28 4 ай бұрын
Yes, we can automate this
@RahulPawar-vl9to 3 ай бұрын
Is there any way to connect with you, I need to perform automation testing on ADF Pipeline, and It's hard to find the solution on this
@surajshrirao-lv2pm 4 ай бұрын
superb teaching I watch all video it was a nice teaching with all basic concept. Nice teaching
@testerhoon28 4 ай бұрын
Thank you 🙏
@Pavan0235 4 ай бұрын
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 4 ай бұрын
Will cover all mentioned points in my next video 👍
@2107varsha1 4 ай бұрын
can you extract tracebility report in ADO?
@testerhoon28 4 ай бұрын
Sure will make a video on that..👍
@mansoorshaik2097 4 ай бұрын
thank u madam ji
@vaibhavrane9979 4 ай бұрын
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 4 ай бұрын
Sure will make vdo on that
@user-ij4ih8qp3e 4 ай бұрын
you are a genius, Ma'am. Thank u, learning a lot from you.
@testerhoon28 4 ай бұрын
Thank u 🙏🙂
@alagandulasandeep9148 4 ай бұрын
English English English English English English English
@testerhoon28 4 ай бұрын
Sure 👍
@vikindahe1642 4 ай бұрын
Thank you for Great video
@alagandulasandeep9148 4 ай бұрын
English English English
@testerhoon28 4 ай бұрын
Will make another same video in English
@uttambongarde6558 4 ай бұрын
Suppose if you have 20GB text file data for the validation. How you are validated this data without using automation tool.
@testerhoon28 4 ай бұрын
To test we have to do the sampling of data and test it
@uttambongarde6558 4 ай бұрын
Thank you @@testerhoon28
@Naru_NNN 4 ай бұрын
informative
@prasadhiremath7675 4 ай бұрын
Good info
@kanchankumar-pt2lp 4 ай бұрын
can you pls help how can we compare production data with test data,if not using any automated tool
@testerhoon28 4 ай бұрын
Okay 👍
@vaibhavrane9979 4 ай бұрын
Hi Mam, ETL me parameter file concept kya hai, kya aap uspar E2E video bana sakti ho. taki hume samjhne me aasani ho. aur usme ETL tester ka kya roles hota hai yah bhi explain kijiyega please.
@testerhoon28 4 ай бұрын
Sure, will make a video on that 👍
@MENTALFLOSSER 4 ай бұрын
How do you indentify and perform regression testing for the database ..what are the basis ..please do let me know .Thank you
@testerhoon28 4 ай бұрын
Okay 👍
@amareshsn2605 4 ай бұрын
Please first give the definition for each question then explain it with examples. So we can understand properly
@testerhoon28 4 ай бұрын
Okay 👍
@AP-tn7yh 4 ай бұрын
How do you validate if source is in DB and target is flatfile
@testerhoon28 4 ай бұрын
Will cover this point in the next video 👍
@dastageerpinjar5065 4 ай бұрын
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 4 ай бұрын
Thank you 🙏
@vaibhavrane9979 4 ай бұрын
Hi Mam, could you please tell me.. is Azure easy to learn than AWS?
@testerhoon28 4 ай бұрын
Yes, Azure is easy to learn. Learn basics of python and pyspark that would be sufficient
@dineshsolanki2022 4 ай бұрын
Complex se complex source sql query likhne ka tarika Complex Target Query likhne ka tarika Or dono complex Query ko kaise validate karte he ….Please Video bannayiye iss par
@testerhoon28 4 ай бұрын
Sure 👍
@user-di1mc6us3l 5 ай бұрын
Hi Mam, it was really helpful, can you please make a video on ETL Testing using Automation using python or Java.
@mohammadmumtaz5029 5 ай бұрын
very nice,
@sumanththanneru9581 5 ай бұрын
please make videos with bit more voice clarity :)
@testerhoon28 5 ай бұрын
Sure 😊
@pravinm1490 5 ай бұрын
very nice mam
@SANJAYYADAV-hm2bs 5 ай бұрын
Thank you so much.
@SANJAYYADAV-hm2bs 5 ай бұрын
Ma'am please make videos on ETL testing using cloud - Azure, AWS, GCP.
@testerhoon28 5 ай бұрын
Sure will make 👍
@venkatasubbareddybakka6589 5 ай бұрын
Actually among 5 vedios - 3 vedios only visible . Can you check once
@testerhoon28 5 ай бұрын
Yes, other invisible videos are paid one
@alagandulasandeep9148 5 ай бұрын
tnq
@MM-gq1vl 5 ай бұрын
Hello .. 1.Do we need to truncate the target table before running the job or how to test when we can not delete the existing data in target table and everytime data gets loaded after running the job 2. How to insert our testdata if already some data is there in the source database
@testerhoon28 5 ай бұрын
Will make a video on your questions..till then stay tuned