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
I applied via Naukri.com and was interviewed in Jul 2022. There were 2 interview rounds.
I applied via Referral and was interviewed in Feb 2023. 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
About pnb. Methamatics test, general knowledge
I applied via Referral and was interviewed in Nov 2021. There were 2 interview rounds.
I was interviewed in Nov 2021.
My day starts with a morning routine that includes exercise, meditation, and planning for the day ahead.
I wake up early and start my day with some light stretching and exercise to energize my body.
Afterwards, I spend a few minutes meditating to clear my mind and set a positive intention for the day.
Once I feel centered, I review my schedule and prioritize tasks, making a to-do list to stay organized.
I also take some ti...
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