Filter interviews by
Top trending discussions
posted on 9 May 2024
The output of 4 joins is a result set that combines data from multiple tables based on specified conditions.
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Processing of joins involves matching rows from the tables based on the specified join condition.
The output of 4 joins would involve combining data ...
Self joins between tables with CTE are used to join a table to itself using Common Table Expressions.
Self joins are used when you need to compare rows within the same table.
CTE is used to create a temporary result set that can be referenced multiple times in a query.
Example: SELECT e1.employee_id, e2.manager_id FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id
Optimizations in Spark involve tuning configurations, partitioning data, using efficient transformations, and caching intermediate results.
Tune configurations for memory and parallelism
Partition data to distribute workload evenly
Use efficient transformations like map, filter, and reduce
Cache intermediate results to avoid recomputation
posted on 8 May 2024
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 3 interview rounds.
I applied via Approached by Company and was interviewed in Jul 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Jul 2022. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.
posted on 25 Dec 2020
posted on 24 Jan 2023
I applied via Referral and was interviewed before Jan 2022. There were 3 interview rounds.
Zonal manger taken the interview along with Area manager
I applied via Referral and was interviewed before Dec 2023. There were 2 interview rounds.
I expect to lead a team to success by setting clear goals, providing support, and fostering a positive work environment.
Set clear goals and expectations for the team
Provide support and resources to help team members succeed
Foster a positive work environment through open communication and recognition of achievements
I am available to join immediately and can start as soon as needed.
Available to start immediately
Flexible with start date
Can join as soon as needed
About pnb. Methamatics test, general knowledge
based on 4 reviews
Rating in categories
Assistant Manager
41
salaries
| ₹5.3 L/yr - ₹19 L/yr |
Senior Manager
17
salaries
| ₹9 L/yr - ₹25.8 L/yr |
Manager
15
salaries
| ₹7.5 L/yr - ₹25.2 L/yr |
Senior Associate
14
salaries
| ₹3 L/yr - ₹5.1 L/yr |
Management Trainee
13
salaries
| ₹9.5 L/yr - ₹17 L/yr |
Aon
Willis Towers Watson
Marsh McLennan
Edelweiss Insurance Brokers