Youtor
ETLTestingInterviewQuestionSeries13WritedowntheSQLQuerytoValidatetheSourcevsTarget
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=VGrCxx0lk-o
As part of the Testing ETL_Testing_Interview_Question_Series here I am going to explain the validations step by step with queries as well. Please contact us for ETL Testing BI Testing Course training: 9886827826 • • CREATE TABLE EMP_SOURCE(EMPID NUMBER(10),STATUS VARCHAR2(20)); • CREATE TABLE EMP_TARGET(EMPID NUMBER(10),STATUS VARCHAR2(20)); • • INSERT ALL • INTO EMP_SOURCE VALUES(123,'FTE') • INTO EMP_SOURCE VALUES(124,'CWR') • INTO EMP_SOURCE VALUES(125,'TER') • INTO EMP_SOURCE VALUES(126,'FTE') • INTO EMP_TARGET VALUES(123,'PERMANANT') • INTO EMP_TARGET VALUES(124,'CONTRACTOR') • INTO EMP_TARGET VALUES(125,'TERMINATED') • INTO EMP_TARGET VALUES(126,'PERMANANT') • SELECT * FROM DUAL; • • SELECT * FROM EMP_SOURCE; • SELECT * FROM EMP_TARGET; • • --metadata validation • • --NO OF COLUMNS SOURCE • --DATATYPE • --DATATYPE LENGTH • --NO OF COLUMNS • --DATA INTEGRITY CHECK • • --RECORD COUNT • • SELECT COUNT(*) FROM EMP_SOURCE; • SELECT COUNT(*) FROM EMP_TARGET; • --RECORD COUNT MATCHED • • --DATA VALIDATION • --DATA TRANSFORMATION • --DATA COMPLETENESS • • • -- source vs TARGET (A-B) • --Target vs Source (B-A) • • --Source side you have apply transformation logic • --target already applied by workflow • • SELECT EMPID,CASE WHEN STATUS='FTE' THEN 'PERMANANT' • WHEN STATUS='CWR' THEN 'CONTRACTOR' • WHEN STATUS='TER' THEN 'TERMINATED' • ELSE 'NA' END AS STATUS FROM EMP_SOURCE • MINUS • SELECT EMPID,STATUS FROM EMP_TARGET; • • SELECT EMPID,STATUS FROM EMP_TARGET • MINUS • SELECT EMPID,CASE WHEN STATUS='FTE' THEN 'PERMANANT' • WHEN STATUS='CWR' THEN 'CONTRACTOR' • WHEN STATUS='TER' THEN 'TERMINATED' • ELSE 'NA' END AS STATUS FROM EMP_SOURCE; • • #sql #etltesting #interview #etl #job #oracle #rank • #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_server #informatica #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_server#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#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#etltesting #etl #dwh #sql #like #regularexpressions #oracle #interview #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#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 #unoin #unionafricaine #unionall #dwh #datalake#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 #data #interview #departmentwiselowestsalary#Analyticalfunctions • #union #it #informatica #groupby #operator #operatorsinjava • #etl testing interview questions and answers #etl interview questions and answers • #etl tester #etl testing interview
#############################
