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?
@sonipk3010 күн бұрын
Thank u for video....
@WonderWorks1718 күн бұрын
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
your voice is not cleared when given the answer of validation part.
@testerhoon2820 күн бұрын
Okay will improve the voice quality 👍
@venkata92824 күн бұрын
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?
@testerhoon2823 күн бұрын
I have explained just to show case how to write an SQL query for such type of scenarios 👍
@venkata92820 күн бұрын
@@testerhoon28 Yes ofcourse. Many thanks for uploading the video and Helping me to understand how to perform report testing!
@ganeshcharipallyАй бұрын
Where we can download etl mapping document to practice informatica
@testerhoon28Ай бұрын
Email me I'll share with you
@jagan2823Ай бұрын
Mam when we will ADF testing concepts would be explained?
@testerhoon28Ай бұрын
Soon I will make a video on that..
@ashishkumar-on8xgАй бұрын
Thankyou for this informative video, explained in very clear and simple way. Thanks
@testerhoon28Ай бұрын
😊👍
@537ASLAMАй бұрын
Excelllent explanation... thanks sister
@testerhoon28Ай бұрын
😊
@kumarrajiv28212 ай бұрын
can make video on how to run etl job
@sravanworld94192 ай бұрын
I have experince in informatica power center is there any growth in informatica other wise i have to upgrade azure adf and databricks
@testerhoon282 ай бұрын
Better to upgrade ADF, ADB for growth
@STEAVEJOBS-kb3dx2 ай бұрын
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-kb3dx2 ай бұрын
Really helpful ❤
@Gowthami9592 ай бұрын
If its in English means it would be more good for the people who doesn't understand Hindi
@testerhoon282 ай бұрын
Now I have started making videos in English...🙏
@riyavenkat26372 ай бұрын
Pls mak it in English r else try to give English caption
@testerhoon282 ай бұрын
Sure 👍
@RahulPawar-vl9to3 ай бұрын
can we do automtion testing on this kindly reply me i want to discuss on this
@testerhoon283 ай бұрын
Yes, we can automate this
@RahulPawar-vl9to2 ай бұрын
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-lv2pm3 ай бұрын
superb teaching I watch all video it was a nice teaching with all basic concept. Nice teaching
@testerhoon283 ай бұрын
Thank you 🙏
@Pavan02353 ай бұрын
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
@testerhoon283 ай бұрын
Will cover all mentioned points in my next video 👍
@2107varsha13 ай бұрын
can you extract tracebility report in ADO?
@testerhoon283 ай бұрын
Sure will make a video on that..👍
@mansoorshaik20973 ай бұрын
thank u madam ji
@vaibhavrane99793 ай бұрын
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?
@testerhoon283 ай бұрын
Sure will make vdo on that
@user-ij4ih8qp3e3 ай бұрын
you are a genius, Ma'am. Thank u, learning a lot from you.
@testerhoon283 ай бұрын
Thank u 🙏🙂
@alagandulasandeep91483 ай бұрын
English English English English English English English
@testerhoon283 ай бұрын
Sure 👍
@vikindahe16423 ай бұрын
Thank you for Great video
@alagandulasandeep91483 ай бұрын
English English English
@testerhoon283 ай бұрын
Will make another same video in English
@uttambongarde65583 ай бұрын
Suppose if you have 20GB text file data for the validation. How you are validated this data without using automation tool.
@testerhoon283 ай бұрын
To test we have to do the sampling of data and test it
@uttambongarde65583 ай бұрын
Thank you @@testerhoon28
@Alltec22333 ай бұрын
informative
@prasadhiremath76753 ай бұрын
Good info
@kanchankumar-pt2lp3 ай бұрын
can you pls help how can we compare production data with test data,if not using any automated tool
@testerhoon283 ай бұрын
Okay 👍
@vaibhavrane99793 ай бұрын
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.
@testerhoon283 ай бұрын
Sure, will make a video on that 👍
@MENTALFLOSSER3 ай бұрын
How do you indentify and perform regression testing for the database ..what are the basis ..please do let me know .Thank you
@testerhoon283 ай бұрын
Okay 👍
@amareshsn26053 ай бұрын
Please first give the definition for each question then explain it with examples. So we can understand properly
@testerhoon283 ай бұрын
Okay 👍
@AP-tn7yh3 ай бұрын
How do you validate if source is in DB and target is flatfile
@testerhoon283 ай бұрын
Will cover this point in the next video 👍
@dastageerpinjar50653 ай бұрын
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"
@testerhoon283 ай бұрын
Thank you 🙏
@vaibhavrane99793 ай бұрын
Hi Mam, could you please tell me.. is Azure easy to learn than AWS?
@testerhoon283 ай бұрын
Yes, Azure is easy to learn. Learn basics of python and pyspark that would be sufficient
@dineshsolanki20223 ай бұрын
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
@testerhoon283 ай бұрын
Sure 👍
@user-di1mc6us3l3 ай бұрын
Hi Mam, it was really helpful, can you please make a video on ETL Testing using Automation using python or Java.
@mohammadmumtaz50294 ай бұрын
very nice,
@sumanththanneru95814 ай бұрын
please make videos with bit more voice clarity :)
@testerhoon284 ай бұрын
Sure 😊
@pravinm14904 ай бұрын
very nice mam
@SANJAYYADAV-hm2bs4 ай бұрын
Thank you so much.
@SANJAYYADAV-hm2bs4 ай бұрын
Ma'am please make videos on ETL testing using cloud - Azure, AWS, GCP.
@testerhoon284 ай бұрын
Sure will make 👍
@venkatasubbareddybakka65894 ай бұрын
Actually among 5 vedios - 3 vedios only visible . Can you check once
@testerhoon284 ай бұрын
Yes, other invisible videos are paid one
@alagandulasandeep91484 ай бұрын
tnq
@MM-gq1vl4 ай бұрын
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
@testerhoon284 ай бұрын
Will make a video on your questions..till then stay tuned
@prasadhiremath76754 ай бұрын
Thanks for info
@akshaysabale17964 ай бұрын
Thank you for giving the valuable information .... 🙏🙏
@user-zg1bm3dp9g4 ай бұрын
Thank you 😊
@sa-pg6or4 ай бұрын
Thank u ☺️
@bodigumakila58234 ай бұрын
Thank you so much mam for your Videos really very helpful. Also can you please help us learn pyspark in etl testing perspective.
Пікірлер
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?
Thank u for video....
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
Email me @ [email protected]
your voice is not cleared when given the answer of validation part.
Okay will improve the voice quality 👍
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?
I have explained just to show case how to write an SQL query for such type of scenarios 👍
@@testerhoon28 Yes ofcourse. Many thanks for uploading the video and Helping me to understand how to perform report testing!
Where we can download etl mapping document to practice informatica
Email me I'll share with you
Mam when we will ADF testing concepts would be explained?
Soon I will make a video on that..
Thankyou for this informative video, explained in very clear and simple way. Thanks
😊👍
Excelllent explanation... thanks sister
😊
can make video on how to run etl job
I have experince in informatica power center is there any growth in informatica other wise i have to upgrade azure adf and databricks
Better to upgrade ADF, ADB for growth
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??
Really helpful ❤
If its in English means it would be more good for the people who doesn't understand Hindi
Now I have started making videos in English...🙏
Pls mak it in English r else try to give English caption
Sure 👍
can we do automtion testing on this kindly reply me i want to discuss on this
Yes, we can automate this
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
superb teaching I watch all video it was a nice teaching with all basic concept. Nice teaching
Thank you 🙏
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
Will cover all mentioned points in my next video 👍
can you extract tracebility report in ADO?
Sure will make a video on that..👍
thank u madam ji
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?
Sure will make vdo on that
you are a genius, Ma'am. Thank u, learning a lot from you.
Thank u 🙏🙂
English English English English English English English
Sure 👍
Thank you for Great video
English English English
Will make another same video in English
Suppose if you have 20GB text file data for the validation. How you are validated this data without using automation tool.
To test we have to do the sampling of data and test it
Thank you @@testerhoon28
informative
Good info
can you pls help how can we compare production data with test data,if not using any automated tool
Okay 👍
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.
Sure, will make a video on that 👍
How do you indentify and perform regression testing for the database ..what are the basis ..please do let me know .Thank you
Okay 👍
Please first give the definition for each question then explain it with examples. So we can understand properly
Okay 👍
How do you validate if source is in DB and target is flatfile
Will cover this point in the next video 👍
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"
Thank you 🙏
Hi Mam, could you please tell me.. is Azure easy to learn than AWS?
Yes, Azure is easy to learn. Learn basics of python and pyspark that would be sufficient
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
Sure 👍
Hi Mam, it was really helpful, can you please make a video on ETL Testing using Automation using python or Java.
very nice,
please make videos with bit more voice clarity :)
Sure 😊
very nice mam
Thank you so much.
Ma'am please make videos on ETL testing using cloud - Azure, AWS, GCP.
Sure will make 👍
Actually among 5 vedios - 3 vedios only visible . Can you check once
Yes, other invisible videos are paid one
tnq
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
Will make a video on your questions..till then stay tuned
Thanks for info
Thank you for giving the valuable information .... 🙏🙏
Thank you 😊
Thank u ☺️
Thank you so much mam for your Videos really very helpful. Also can you please help us learn pyspark in etl testing perspective.
Okay 👍