i
Perficient
Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2021. There was 1 interview round.
Rank and dense rank are used to assign a rank to each row in a result set based on the values in a specific column.
Rank assigns unique ranks to each row, with gaps in the ranking sequence if there are ties.
Dense rank assigns unique ranks to each row, with no gaps in the ranking sequence if there are ties.
Rank and dense rank are commonly used in data analysis and reporting to identify top performers or outliers.
Example:...
SCD stands for Slowly Changing Dimensions. There are three types of SCD: Type 1, Type 2, and Type 3.
Type 1: Overwrite the old data with new data.
Type 2: Create a new record for the new data and keep the old record.
Type 3: Create a new column for the new data and keep the old column.
Top trending discussions
I applied via Recruitment Consultant and was interviewed before Sep 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before May 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.
I applied via Recruitment Consultant and was interviewed before Apr 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.
Java is platform independent due to its bytecode and JVM.
Java code is compiled into bytecode which is platform-independent.
JVM (Java Virtual Machine) interprets the bytecode and executes it on any platform.
JVM acts as an abstraction layer between the Java code and the underlying hardware.
This allows Java programs to run on any platform that has a JVM installed.
For example, a Java program written on a Windows machine ca...
I applied via Recruitment Consultant and was interviewed before Oct 2020. There was 1 interview round.
based on 1 interview
Interview experience
Technical Consultant
840
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Technical Consultant
432
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Technical Consultant
321
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Leader Consultant
206
salaries
| ₹0 L/yr - ₹0 L/yr |
Softwaretest Engineer
185
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
TCS
Infosys
Wipro