Bro, you will go to heaven!

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

Excellent explanation and examples.. Helpful video!!

Awesome information sir tqq for sharing it helps a lot

Thank you so much for this video sir.

Very helpful sir... sometimes experience candidates also struggling to tell this to the interviewer

Very nice explanation

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

Whitespace bug.. Good one..fq😊

Thank u.. It help me a lot

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

Great

@etlqalabs5048

5 ай бұрын

Thanks for encouragement. Keep sharing and keep learning

@ashokbhum06

5 ай бұрын

May I have your email id

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

Hi Hetu, pls explain abt high severity and priority defects

Primary key,foreign key are clear but explain superkey, surrogate key,natural key,composite key,alternative key, candidate key..(very imp for interview) Explain with simple examples to.crack interview?!! Thanks for u r efforts sir...

@etlqalabs5048

2 жыл бұрын

kzread.info/dash/bejne/c5qq0JqeYajfmdY.html Take a look at SQL playlist , alot of things are covered already

100% use sir

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

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

2 жыл бұрын

Please watch recent videos

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;

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

2 жыл бұрын

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

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

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

2 жыл бұрын

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.

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

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

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.

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

@etlqalabs5048

2 жыл бұрын

Please watch this already done earlier kzread.info/dash/bejne/jIWHq8meqLXLpNY.html

Make a video on Testing Triggers, stored procedure , function

@etlqalabs5048

2 жыл бұрын

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

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

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

@etlqalabs5048

2 жыл бұрын

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

@ajaydubey6937

2 жыл бұрын

@@etlqalabs5048 ok thank you sir

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

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

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.

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

@etlqalabs5048

2 жыл бұрын

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

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

@etlqalabs5048

2 жыл бұрын

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

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

2 жыл бұрын

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

@venkatasubramaniam3643

2 жыл бұрын

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

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