i
HCLTech
Filter interviews by
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
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...
What people are saying about HCLTech
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
I applied via Company Website and was interviewed before Apr 2021. There were 3 interview rounds.
I applied via Walk-in and was interviewed before May 2021. There were 3 interview rounds.
I was interviewed in May 2017.
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Software Engineer
23.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
21.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
15.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Engineer
15k
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
14.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Accenture
Cognizant