Interview Questions

ETL Testing Interview Questions and Answers

Interview Questions December 29, 2018
ETL Testing Interview Questions and Answers

ETL Testing Interview Questions and answers

ETL Testing Interview Questions and answers for beginners and experts. List of frequently asked ETL Testing Interview Questions with answers by Besant Technologies. We hope these ETL Testing Interview Questions and answers are useful and will help you to get the best job in the networking industry. This ETL Testing Interview Questions and answers are prepared by ETL Testing Professionals based on MNC Companies expectations. Stay tuned we will update New ETL Testing Interview Questions with Answers Frequently. If you want to learn Practical ETL Testing Training then please go through this ETL Testing Training in Chennai.

Best ETL Testing Interview Questions and answers

Besant Technologies supports the students by providing ETL Testing Interview Questions and answers for the job placements and job purposes. ETL Testing is the leading important course in the present situation because more job openings and the high salary pay for this ETL Testing and more related jobs. We provide the ETL Testing online training also for all students around the world through the Gangboard medium. These are top ETL Testing Interview Questions and answers, prepared by our institute experienced trainers.

ETL Testing Interview Questions and answers for the job placements

Here is the list of most frequently asked ETL Testing Interview Questions and answers in technical interviews. These questions and answers are suitable for both freshers and experienced professionals at any level. The questions are for intermediate to somewhat advanced ETL Testing professionals, but even if you are just a beginner or fresher you should be able to understand the answers and explanations here we give.

Q1) What is ETL Testing and how its not the same as database Testing?

ETL testing applies to Data Warehouses or Data joining ventures while Database Testing applies to any database holding information (regularly exchange frameworks). Here are the abnormal state tests done in each:

ETL Testing: Primary objective is to check if the information moved appropriately not surprisingly

Database Testing: Primary objective is to check if the information is following the guidelines/benchmarks characterized in the Data Model

ETL Testing :

  • Confirm that the checks in the source and target are coordinating
  • Confirm that the information is coordinating among source and target
  • Confirm that the changed information is according to desire
  • Confirm that the information is gradually getting refreshed
  • Confirm that the remote – essential key relations are safeguarded amid the ETL
  • Confirm if there are any copies in the stacked information

Database Testing :

  • Check that the remote – essential key relations are kept up and there are no vagrant records
  • Check that the information in the sections had substantial qualities. eg. On the off chance that there is an area (encoded list) characterized for a section, check if the qualities in the segment meet that prerequisite
  • Check that the information in segments is precise. eg. In the event that you have an age segment, does it have values more than 100
  • Confirm if information is absent in sections where required. eg. On the off chance that is a section is relied upon to have information dependably, check if there are any invalid qualities.
Q2) what are the smoke test can be performed on the ETL Testing?
  • primary key
  • duplicate key check
  • table completeness
  • Referential interigity
  • cdc check
Q3) What are ETL tester responsibilities?
  • prepare the test plan,test scenario and test case according to the requirement
  • walkthrough all the test artificat with team
  • ensure that environemt is ready before running
  • ensure to perform smoke test
  • verify that data is correctly moved from src to target system with necessary transformation
Q4) if there are ten thousand records in a source system, how do we ensure that all ten thousand are loaded to the target without any function
src query

minus

target query

output should result 0 records if src and target is in sync

Q5) How you will display all the columns in the table?

select * from tablename (where * indicates all the columns in the columns)

Q6) How to chk the Primary Key?
assume we have (student_id as a primary key in the student table)

select

student_id,

count(*)

from

student

having

count(*) >1
Q7) how to chk is there any duplicate records is exists in the table?

assume we have student table with columns student_id,student_name,dept_id,phone_number

select

student_id,student_name,dept_id,phone_number,count(*) from

student

group by

student_id,student_name,dept_id,phone_numb

having count(*)>1
Q8) Assume we have employees table (around 100) record. write a query to find the which employess as joined first in the organisation?
select a.* from

(

select employee_id,first_name,last_name,rank() over(order by hire_date asc) as rk from

employees

)a

where a.rk=1
Q9) what are various set operators available in SQL?
  • union
  • union all
  • intersect
  • minus
Q10) write a query to calcualted how many employees on each department?
select

department_id,

count(*)

from

employees

group by department_id
Q11) select all the employees where third charcter of first_name is ‘a'
select * from

employees

where first_name like ‘__a%’;
Q12) how to check whether table has been loaded with data are not?
select count(*) from employees

having count(*) >=1
Q13) write a query to updated all the employess salary base don department
if dept_id in 10,20 then increase by 0.25

if dept_id =30 then increase by 0.20

if dept_id in 40,50  then increase by 0.15

if dept_id > then increase by 0.10

update employees

set salary =salary + (case when dept_id in (10,20) then salary *0.25

when dept_id=30 then salary*0.20

when dept_id in (40,50) then salary*0.15

else salary *0.10

)
Q14) write the query to find second max salary in each department
select a.* from

(

select employee_id,first_name,last_name,rank() over (partition by department_id order by salary desc) as rk

from employees

)a

where a.rk=2
Q15) compose a question to refreshed employess somewhere in the range of 150 and 180 compensation dependent on office
on the off chance that dept_id in 10,20, increment by 0.25

on the off chance that dept_id =30, increment by 0.20

on the off chance that dept_id in 40,50, increment by 0.15

on the off chance that dept_id >, increment by 0.10

refresh representatives

set compensation =salary + (situation when dept_id in (10,20) at that point pay *0.25

at the point when dept_id=30 then salary*0.20

at the point when dept_id in (40,50) at that point salary*0.15

else compensation *0.10

)

where employee_id somewhere in the range of 150 and 180;
Q16) how to make another table from effectively existing table with no information
make tablename as

select * from tablename where 1=2
Q17) how to make another table from effectively existing table with any information make table tablename as
select * from tablename where 1=1
Q18) what is the contrast among subquery and correclated subquery

Related Subquery is a sub-question that utilizes values from the external inquiry. For this situation the inward question must be executed for each column of external inquiry.

Basic subquery doesn’t utilize values from the external inquiry and is being determined just once

Q19) what are the joins accessible in sql
  • inner join
  • outer join
  • left external join
  • right external join
  • full external join
  • self join
  • cross join or cartesian item
Q20) write a question to discover the which supervisor has overseeing in excess of 5 representatives.
SELECT FIRST_NAME FROM EMPLOYEES

WHERE EMPLOYEE_ID IN

(SELECT MANAGER_ID FROM EMPLOYEES

Gathering BY MANAGER_ID

HAVING COUNT(*)>5)
Q21) write a query to find all the jobs for which employees are joined in the current year.

SELECT * FROM JOBS WHERE JOB_ID IN

(SELECT JOB_ID FROM EMPLOYEES WHERE TO_CHAR(HIRE_DATE,’YYYY’)=TO_CHAR(SYSDATE,’YYYY’))

Q22) write a query to find all the employees working in deptartment 10,50,60

select * from employees where department_id in (10,50,60)

Q23) what are the commands are available in SQL” open=”no” style=”default” icon=”plus” anchor=”” class=””]

  • DDL-data definition lanag
  • DML-data muniplation lanag
  • DCL-data control lanag
  • TCL-transcation control lanag
Q24) Difference among rank and thick position?

RANK gives you the positioning inside your arranged segment. Ties are appointed a similar position, with the following ranking(s) skipped. Along these lines, on the off chance that you have 3 things at rank 2, the following position recorded would be positioned 5.

DENSE_RANK again gives you the positioning inside your arranged parcel, yet the positions are continuous. No positions are skipped if there are positions with different things.

Q25) Write a question to discover how long representatives has functioned from is hire_date

select sysdate – to_date(Hire_date) from representatives

Q26) write a question to show every one of the workers where initial 3 letter of first_name is bab
select * from representatives where instr(first_name,1,3)=’bab’

compose an inquiry to discover total of salries for each department_id

select department_id,

sum(salary)

from

workers

amass by department_id
Q27) write an inquiry to discover total of salries of departement_id is 50000
select department_id,

sum(salary)

from

workers

gather by department_id

having sum(salary)>50000
Q28) Write an inquiry to discover what number of workers has joined following 15 of the present month

SELECT COUNT(*) FROM EMPLOYEES WHERE TO_CHAR(HIRE_DATE,’DD’) > 15

Q29) A question to show full name(first_name, last_name) and join_date for every one of the workers who have joined somewhere in the range of 2015 and 2018

SELECT concat(FIRST_NAME,concat(“,”,last_name)) as fullname, HIRE_DATE FROM EMPLOYEES

WHERE TO_CHAR(HIRE_DATE, ‘YYYY’) BETWEEN 2015 AND 2018 ORDER BY HIRE_DATE

Q30) write a question to number of month representatives has working in organization

select employee_id,months_between(sysdate,hire_date) from representatives

Q31) write a question to discover every one of the representatives who have participated in the long stretch of Jan

SELECT * FROM EMPLOYEES WHERE TO_CHAR(HIRE_DATE, ‘MON’)= ‘Jan’

Q32) write a query to match abc=ABC

select upper(abc)=’ABC’ from dual

Q33) write a query to display all the employees salary in 10 digit

example 2600->0000002600

17000->0000017000

select salary,rpad(salary,10,0) from  employees

Q34) difference between lpad and rpad

select ltrim(‘    hello world’),rtrim(‘hello world     ‘) from dual;

o/p

ltrim(‘    hello world’) rtrim(‘hello world     ‘)

hello world               hello world

Q35) write a query to find number of employees under each manager

select manager_id,count(employees_id) from employees group by manager_id

Q36) various aggregate function
  • max()
  • min()
  • sum()
  • avg()
  • count()
Q37) various logicaloperators
  • and
  • or
  • not
Q38) list few ETL tool available in the market
  • informatica
  • abinto
  • ssis
Q39) various way to compare txt file with data in the table
  • load the txt file data into access and bring sql data into access and compare both in access database
  • by using unix script we can compare (ensure both the output are extracted in txt file)

Besant Technologies – Chennai & Bangalore Branch Locations

Besant Technologies - Velachery Branch

Plot No. 119, No.8, 11th Main road, Vijaya nagar,

Velachery, Chennai - 600 042

Tamil Nadu, India

Landmark - Reliance Digital Opposite Street

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - Tambaram Branch

No.2A, 1st Floor, Duraisami Reddy Street,

West Tambaram, Chennai - 600 045

Tamil Nadu, India

Landmark - Near By Passport Seva

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - OMR Branch

No. 5/318, 2nd Floor, Sri Sowdeswari Nagar,

OMR, Okkiyam Thoraipakkam, Chennai - 600 097

Tamil Nadu, India

Landmark - Behind Okkiyampet Bus Stop,

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - Porur Branch

No. 180/84, 1st Floor, Karnataka Bank Building,

Trunk Road, Porur, Chennai - 600 116

Tamil Nadu, India

Landmark - Opposite to Gopalakrishna Theatre

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - Anna Nagar Branch

Plot No:1371, 28th street kambar colony,

I Block, Anna Nagar, Chennai - 600 040

Tamil Nadu, India

Landmark - Behind Reliance Fresh

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - T.Nagar Branch

Old No:146/2- New No: 48,

Habibullah Road,T.Nagar, Chennai - 600 017

Tamil Nadu, India

Landmark - Opposite to SGS Sabha

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - Thiruvanmiyur Branch

22/67, 1st Floor, North mada street, Kamaraj Nagar

Thiruvanmiyur, Chennai 600041

Tamil Nadu, India

Landmark - Above Thiruvanmiyur ICICI Bank

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - Siruseri Branch

No. 4/76, Ambedkar Street, OMR Road, Egatoor, Navallur,

Siruseri, Chennai 600130

Tamil Nadu, India

Landmark - Near Navallur Toll Gate, Next to Yamaha Showroom

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - Maraimalai Nagar Branch

No.37, Ground Floor, Thiruvalluvar Salai,

Maraimalai Nagar,Chennai 603209

Tamil Nadu, India

Landmark - Near to Maraimalai Nagar Arch

  +91-8099 770 770

  info@besanttechnologies.com

Besant Technologies - BTM Layout Branch

No 2, Ground floor, 29th Main Road,

Kuvempu Nagar,BTM Layout 2nd Coming from Silkboard,

AXA company signal, Stage, Bangalore - 560 076

Karnataka, India

Landmark - Next to OI Play School

  +91-8767 260 270

  info@besanttechnologies.com

Besant Technologies - Marathahalli Branch

No. 43/2, 2nd Floor, VMR Arcade,

Varthur Main Road, Silver Springs Layout,

Munnekollal, Marathahalli, Bengaluru - 560037

Karnataka, India

Landmark - Near Kundalahalli Gate Signal

  +91-8767 260 270

  info@besanttechnologies.com

Besant Technologies - Rajaji Nagar Branch

No. 309/43, JRS Ecstasy, First Floor,

59th Cross, 3rd Block, Bashyam Circle,

Rajaji Nagar, Bangalore - 560 010

Karnataka, India

Landmark - Near Bashyam Circle

  +91-8767 260 270

  info@besanttechnologies.com

Besant Technologies - Jaya Nagar Branch

No. 2nd Floor,1575,11th Main Road,

4th T-Block, Pattabhirama Nagar,

Jaya Nagar, Bangalore - 560 041

Karnataka, India

Landmark - Opposite to Shanthi Nursing Home

  +91-8767 260 270

  info@besanttechnologies.com

Besant Technologies - Kalyan Nagar Branch

No.513, 4th Cross Rd

2nd Block, HRBR Layout,

Kalyan Nagar, Bangalore - 560 043

Karnataka, India

Landmark - Opposite to kalayan nagar Axis Bank

  +91-8767 260 270

  info@besanttechnologies.com

Besant Technologies - Electronic City Branch

No. 7, 3rd Floor, Ganga Enclave,

Neeladri Road, Karuna Nagar, Doddathoguru Village,

Electronics City Phase 1, Electronic City,

Bangalore - 560100, karnataka, India

Landmark - Adjacent to HDFC Bank and State Bank Of India

  +91-8767 260 270

  info@besanttechnologies.com

Besant Technologies - Indira Nagar Branch

No.54, 1st Floor,

5th Main kodihalli,

Bengaluru, Karnataka 560008, India

Landmark - Behind Leela Palace Hotel,

  +91-8767 260 270

  info@besanttechnologies.com

Besant Technologies - HSR Layout Branch

Plot No. 2799 & 2800, 27th Main,

1st Sector, HSR Layout,

Bengaluru, Karnataka 560102, India

  +91-8767 260 270

  info@besanttechnologies.com

Besant Technologies - Hebbal Branch

No.29, 2nd Floor, SN Complex,

14th Main Road, E-Block Extention, Sahakara Nagar,

Bengaluru, Karnataka -560092, India

  +91-8767 260 270

  info@besanttechnologies.com

Scroll Up