ETL Testing | Top Challenges in ETL Testing | Common ETL Defects/BUG

[@ArifRaza]

Very useful information. Wonderful explanation

[@manojkumarhk5696]

Bro, you will go to heaven!

[@PradeepKumar-pq4hh]

Very Very helpful.... Thank you sir please keep posting this kind of videos...

[@baranisenthil2714]

Excellent explanation and examples.. Helpful video!!

[@jadhavsonali1452]

Thank you sir, you explain very well

[@dileepkumargvs7296]

Awesome information sir tqq for sharing it helps a lot

[@Crazy_Experimental_Show]

Very nice explanation

[@reena7036]

Sir thank you so much for such an informative videos. Plz do more and detail videos on test cases.

[@surajpatil3579]

Please do coverage on etl automation... by using python or other language 🤔 how can we automate ETL process in some extent?

[@srinivasdwht6278]

Thank you so much for this video sir.

[@vijayalakshmikondepudi3263]

Hi Hetu, This is was asked to me in Infy Interview In Source table there are 150 rows ,after loading into staging table only 100 rows are visible,as a tester how and what will you check first?what could be the issue with the 50 rejected rows?What is the approach?pls help me on this,Thankyou

[@etlqalabs5048]

You can check below things but limited to this only 1. Check if there is any filter applied and may be genuine case because we don't want unnecessary rows extraction from source 2. Check if Stagging table is defined with primary key constraints which will only allow single row with that primary key

[@vijayalakshmikondepudi3263]

@@etlqalabs5048 thankyou so much 😊 for the reply

[@gopiraju5804]

hi please explain, i have one question which i have faced in interview? if source db have no access then what you do.

[@girishtb6984]

sir can you explain about High severity,High Priority defects in ETL and in which scenarios the job will fail and how to perform retesting and regression testing with example

[@etlqalabs5048]

Hope you get the video on severity and priority from ETL testing perspective

[@ashokbhum06]

Great

[@etlqalabs5048]

Thanks for encouragement. Keep sharing and keep learning

[@ashokbhum06]

May I have your email id

[@ajaydubey6937]

Can we map the data into more than 2 tables in target dB by using router transformation?

[@etlqalabs5048]

yes - Router in informatica have ability to direct the output to multiple tables

[@ajaydubey6937]

@@etlqalabs5048 ok thank you sir

[@vinayrb8682]

Can u take up date functions using to_char and to_date for fetching weekly /quarterly data ex: salary etc also on QTD and YTD . Some examples on pivot in next video.

[@etlqalabs5048]

Please watch recent videos

[@sagararya288]

In real time projects, FF or CSV files have millions of records and while testing, it would take reasonably longer time to run etl jobs and executing SQL queries. My question is, do we need to consider only a part of data( as test data) and check it or do we need to check entire data. If need to check entire data, then is there any technique to improve performance of query execution/ETL jobs.

[@kartikjuneja7807]

1) No, we can't improve the performance. It totally depends upon the Dev that how he has written the code or mainly the indexing thing they have done. 2) We can take random data and test it manually 3) we can load the data in staging and then compare or check it.

[@waseemAkram-qc2vm]

Hi sir, What will be test case for SCD 2 ?

[@etlqalabs5048]

Please watch this already done earlier kzbin.info/www/bejne/kIK2epqbrbeYqtU

[@heartbeatzzz3250]

Hi Sethu. Thank you for wonderful videos. It's nice to know more and more about Etl testing. And learnt a lot from your videos. One request, Please make a dedicated video only for FLAT FLIE as a source and how can they be tested and how to perform testing if both source and target are different and please explain with an example and please provide real time interview questions and how to answer them. Great work Thank you

[@anshuldhore2771]

CAN YOU TELL ME WHICH SOFTWERE WE CAN USE FOR TESTING;

[@raghur2074]

Hi Hetu, pls explain abt high severity and priority defects

[@PradeepKumar-pq4hh]

Sir if possible can you make one video on managerial round questions... What kind of situational questions they may ask in Managerial round

[@adityarathore3730]

Very helpful sir. Can you please upload the videos on challenges faced by ETL developers in Project?

[@ShivaM-sh8uk]

Sir white box testing done by etl developer tester won't perform white box testing

[@etlqalabs5048]

Whitebox testing meaning , checking the code in simple term so as developer perform unit testing based on the flow of the codebase similarly ETL tester also checks the mapping and transformation in ETL besides running the workflows ( blackbox testing ). Hence ETL tester does both white and blackbox testing in some cases but this is not necessary every project allows tester to look into code so it depends on project teams and test strategy

[@samidhathokare2115]

Thank u.. It help me a lot

[@chinna7681]

100% use sir

[@nikleshdhawale1962]

we have 100 unique records in source and 150 unique records in target then how you will validate data ?

[@sarangmate1594]

If interviewer asked what is critical part in your telicom domain bss part project then what should be the answer for this question? Please answer sir.

[@sandhyaveeresh6874]

What are production issues you faced during your project ?? Interview question

[@etltesting6148]

Make a video on Testing Triggers, stored procedure , function

[@etlqalabs5048]

Will plan to do a series in future , these topics could be part of database testing

[@jagadishmoger9228]

Sir, Could you please explain how to overcome the few challenges with example

[@sunilkumarv7040]

Sir plz tell me about framework for etl an tester...

[@murapalasivannarayana2808]

sir plz make a video on how to run ETL Job thanks in advance

[@etlqalabs5048]

Please check Informatica playlist on this channel, i have executed the workflow after designing at the end in informatica , that should give you fair ideas but do let me know if you still need me to do a seperate video if required

[@ramprasadg278]

Sir gi ur voice is very low could u make sure while recording iam watching in highest volume but it comes low sound pls check before record or upload pls pls

[@etlqalabs5048]

Ok noted , please check the recent video if that's ok

[@venkatasubramaniam3643]

Yes the volume is very low. I think he recorded with low volume.

[@NikhatParveen-xb8tc]

What can be most common SQL Queries used in ETL Testing?

[@etlqalabs5048]

I have covered good amount of probable questions on etl testing in Etl testing and SQL series. Suggest you to refer.

[@chintunaresh6847]

VOLUME WAS LOW, PLZ TAKE CARE FOR UPCOMING VIDEOS....