วีดีโอ

Your unix command execution is not visible in this video, Can you please make it right and re-upload it please? Otherwise great video, very informative.

Hello sir, Your all videos are very clear to understand . when we get the next part of this video?

Very well explained 😊😊😊

Hello Sir, Do you have any batch for ETL automation Testing with Python ?

how come you have empid column in table dept, isn't it the other way around? the employee table should have a deptid not dept table will have empid. wrong table design

Nice please do more videos like checking duplicate

Thanku sir.I have followed u r videos .nice explanation

Please make more videos in azure series please please 🙏

Even if the values are given along with the code or given in the config file, it's still the hard coded values right? Its not directly reading from mapping

please create video on telecom billing project and bss ns oss ND CRM

I have experience in Manual testing but not have in ETL and SQl.Can i apply job for ETL.

Do we need to have python knolwedge for pyspark?

Thank you for this valuable interview, expecting more this kind of interviews

I'm unable to see your screen for the last question:- Below are my solutions. Approach1:-select nvl(substr(c1,1,instr(c1,' ',1,1)-1),c1) from source; Approach 2:-select case when instr(c1,' ',1,1)>0 then substr(c1,1,instr(c1,' ',1,1)-1) else c1 end as target from source

Wipro Interview questions - 1. So we have a table with 100 columns out of which 20 are direct move and 80 have some transformation rule. What will be your approach to test those 80 columns. 2. What is blank and null, how will you replace null with blank in column. 3. So we have unstructured file in source and developer moved these data in stage with RDBMS format. how will you validate the data? Could you please consider above question for next video?

Most of the questions will be based on SQL? They will not ask much on ETL tool we used and unix? Can you please clarify sir?

thanks for this valuable interview ,need more interviews and for automation is pandas good enough ?

Nice explanation about rank,dense_rank and row_number

Hi Raveendra, we can solve this problem without using case statement also right?. I have written one query SELECT DEPT_ID,SALARY FROM( SELECT DEPT_ID,SALARY, DENSE_RANK() OVER (PARTITION BY DEPT_ID ORDER BY SALARY) AS RNK FROM Employee)A WHERE RNK=1;

This video is enough to clear the interviews and I have cleared 2 companies interviews just by watching it. Thanks for it and please let me know like when the batch gonna start and will be joining it.

Nice explanation

Thank you your way of explanation is very good to understanding

It's really very good explanation thank you

It's very easy to understanding as your explanation thank you

When will start new batch Please share ur number

It's very clear explanation to understanding the subject very nice Thank you

It's very good clear explanation

thanks. please continue this type of interview.

Thank you so much, it is very helpful for who are preparing for the ETL testing. Please do more mock interviews like this, so that it will be very helpful to us.

How do you estimate the efforts in agile methods?

Your explanation is that I can understand very easy it's useful for us . Thanks for this kind of video more useful for us.

how can he get the job without unix and pyhon knowledge

Thanks so much for sharing this, it really helped

This was really informative and well-explained. Thanks so much for sharing this, it really helped!

Thanks so much for sharing this, it really helped❤😊

good content sir. 👏

good explanation sir👏

It's helpful video for us..

good content sir!!!!!!!!!!!!!!!!!!!!!!!1

Good Content!!

Good Content and please provide more such interviews, it helps us so much. Thank you😊

Thanks for providing inputs on the ETL Testing Automation interview and how to tackle the interview as well. It's gives me enough confidence before jumping into actual Interviews. Kudos to you Thank you😊