i
Hexaware Technologies
Filter interviews by
I was interviewed before Oct 2022.
Star schema has a single fact table connected to multiple dimension tables, while snowflake schema has normalized dimension tables.
Star schema denormalizes dimension tables, making it easier to query but potentially less efficient for storage.
Snowflake schema normalizes dimension tables, reducing redundancy but potentially making queries more complex.
Star schema is commonly used for data warehouses with denormalized da...
The GROUP BY clause is used in SQL to group rows that have the same values into summary rows.
It is used with aggregate functions like COUNT, SUM, AVG, etc.
It helps in summarizing data and generating reports.
It is often used in conjunction with the HAVING clause to filter grouped data.
Example: SELECT department, COUNT(employee_id) FROM employees GROUP BY department;
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
What people are saying about Hexaware Technologies
Scenario based with power BI UI creation
Power BI is a business intelligence tool used for data visualization and analysis.
Power BI allows users to connect to various data sources such as databases, Excel files, and online services.
Users can create interactive reports and dashboards using Power BI's drag-and-drop interface.
Power BI offers a wide range of visualization options like charts, graphs, and maps to present data effectively.
Users can share their repo...
Power BI reports are visual representations of data insights, created using Power BI Desktop or Power BI Service.
Power BI reports are interactive and customizable
They can include various visualizations like charts, graphs, tables, and maps
Reports can be shared and accessed online through Power BI Service
Data can be refreshed in real-time or scheduled updates
posted on 8 Apr 2022
Scenario based with power BI UI creation
Power BI is a business intelligence tool used for data visualization and analysis.
Power BI allows users to connect to various data sources such as databases, Excel files, and online services.
Users can create interactive reports and dashboards using Power BI's drag-and-drop interface.
Power BI offers a wide range of visualization options like charts, graphs, and maps to present data effectively.
Users can share their repo...
Power BI reports are visual representations of data insights, created using Power BI Desktop or Power BI Service.
Power BI reports are interactive and customizable
They can include various visualizations like charts, graphs, tables, and maps
Reports can be shared and accessed online through Power BI Service
Data can be refreshed in real-time or scheduled updates
posted on 8 Apr 2022
posted on 25 Nov 2021
I applied via Recruitment Consultant and was interviewed in Oct 2021. There were 3 interview rounds.
based on 6 reviews
Rating in categories
Senior Software Engineer
3.8k
salaries
| ₹5.4 L/yr - ₹20 L/yr |
System Analyst
3k
salaries
| ₹7 L/yr - ₹25.7 L/yr |
Software Engineer
2.9k
salaries
| ₹2 L/yr - ₹10 L/yr |
Senior Executive
2k
salaries
| ₹0.8 L/yr - ₹6 L/yr |
Technical Architect
2k
salaries
| ₹9.4 L/yr - ₹35.5 L/yr |
Cognizant
TCS
Infosys
Wipro