ETL Testing Real Time Scenario-1

Hi Guys
As part of SQL Interview Question Series I have explained below question.
Write down the SQL Query to fetch 50% rows from total records?
github link for SQL Code for practice: github.com/ram...
#ntile #pyhon #etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql #sql_server #postgresql #postgres #dataanalytics #hdfs #sql #development #pyhon #dwh #plsql #db2 #dataengineer #teradata #dataengineer #mssqlserver #msdhoni #msexcel #interview #interviewquestions #views #subquery #inlineview #businessanalystcourse #businessanalyst #sybase #postgres #mssqlserver

[@RamaKrishna-mp5cm]

hi sir your explained about the validation topic very well and it is very easy to understand. thanks for your sharing mentality with free of cost this kind of videos. good luck for SRT team

[@Pattypatpat7122]

Excellent! Do you think it's helpful to write the results of your testing to a control table? e.g. perform a duplicate check, a null check, a minus check and row counts. I feel that this could be helpful for scenarios where ETL jobs fail. Also the control tables can indicate where in the ETL process the job is, so that users are aware of when their data is ready for consumption.

[@amalpeters]

For Data Integrity validation ,For find Constraints we can use below query also
SELECT constraint_name, constraint_type, table_name
FROM user_constraints where table_name='EMPLOYEES';

[@Nalini08888]

Nice Explained....Thank u for the Video

[@vikindahe1642]

Thanks for Amazing Content

[@SANJAYYADAV-hm2bs]

Thanks for providing amazing contents.

[@amalpeters]

Excellent

[@indiansyndicate6881]

Thank you sir For THISE very IMPORTANT INFO VEDIO

[@Rajurock32]

Thank you sir

[@jyothikamatham98]

Thanks a million

[@Naru_NNN]

informative

[@komalishware]

thank you

[@rajatnagwal7881]

Hi Ravindra ,You have made a very good content,currently i am working on airflow if you have some idea how we can test it using python automation ,please let me know

[@srtechnologiesravindraredd5303]

Connect with me on 98862827826 and explain me what is the exact requirement

[@rajatnagwal7881]

@@srtechnologiesravindraredd5303 this number is invalid Ravindra could you please reverify once

[@sandeepthakur8972]

Can you provide SQL PPT please.

[@ramojiguptha3950]

Hi sir will you provide training

[@srtechnologiesravindraredd5303]

Yes we do that

[@ramojiguptha3950]

@@srtechnologiesravindraredd5303 will you please share contact details. So I will approach you

[@ramojiguptha3950]

​@@srtechnologiesravindraredd5303I didn't see any contact on video. So please provide number. So I will call you

[@udaykumarreddy5023]

How can we contact?

[@srtechnologiesravindraredd5303]

Please contact the number which I have shared in the videos