HCLTech ETL Tester Interview Questions and Answers

Inner join combines rows from two tables based on a related column between them.

• Inner join returns only the rows that have matching values in both tables

• It is used to retrieve data that exists in both tables

• Example: SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

Cross join combines each row from one table with each row from another table.

• Cross join produces a Cartesian product of the two tables involved.

• It does not require any common columns between the two tables.

• It can result in a large number of rows if the tables are big.

• Example: SELECT * FROM table1 CROSS JOIN table2;

Different types of data validation and checks in ETL testing include schema validation, data completeness checks, data transformation checks, and data quality checks.

• Schema validation ensures that the data conforms to the expected structure and format.

• Data completeness checks verify that all expected data is present and accounted for.

• Data transformation checks ensure that data is accurately transformed according to bus...read more