Filter interviews by
The RANK function assigns a unique rank to each row within a partition of a dataset based on specified criteria.
RANK function is used in SQL to assign a rank to each row within a partition of a result set.
It can handle ties by assigning the same rank to identical values, skipping subsequent ranks. For example, if two rows are tied for rank 1, the next rank will be 3.
Commonly used in scenarios like ranking students...
SCD stands for Slowly Changing Dimensions, which manage historical data in data warehousing.
SCD Type 0: Retain original data without tracking changes. Example: Static attributes like a product's SKU.
SCD Type 1: Overwrite old data with new data. Example: Updating a customer's address without keeping the old one.
SCD Type 2: Create a new record for each change, preserving history. Example: Tracking changes in a custo...
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is unique
It can be a single column or a combination of columns
Primary key values cannot be NULL
Union combines and removes duplicates, while union all combines without removing duplicates.
Union removes duplicates from the result set, while union all does not.
Union is slower than union all because it has to perform an additional step to remove duplicates.
Union all is used when duplicates are desired in the result set.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 ...
What people are saying about Accenture
Union, Union All, and Difference are SQL set operators used to combine or compare data from multiple tables.
Union combines the results of two or more SELECT statements and removes duplicates.
Union All combines the results of two or more SELECT statements and includes duplicates.
Difference (also known as Except) returns only the rows from the first SELECT statement that are not in the second SELECT statement.
All th...
Advanced SQL techniques for handling large datasets
Use indexing to improve query performance
Optimize queries by avoiding unnecessary joins and subqueries
Utilize partitioning and clustering to manage large tables efficiently
Consider using window functions for complex analytical queries
Some tools used for ETL testing include Informatica, Talend, SSIS, and Apache Nifi.
Informatica
Talend
SSIS (SQL Server Integration Services)
Apache Nifi
I appeared for an interview in Mar 2025, where I was asked the following questions.
SCD stands for Slowly Changing Dimensions, which manage historical data in data warehousing.
SCD Type 0: Retain original data without tracking changes. Example: Static attributes like a product's SKU.
SCD Type 1: Overwrite old data with new data. Example: Updating a customer's address without keeping the old one.
SCD Type 2: Create a new record for each change, preserving history. Example: Tracking changes in a customer's...
The RANK function assigns a unique rank to each row within a partition of a dataset based on specified criteria.
RANK function is used in SQL to assign a rank to each row within a partition of a result set.
It can handle ties by assigning the same rank to identical values, skipping subsequent ranks. For example, if two rows are tied for rank 1, the next rank will be 3.
Commonly used in scenarios like ranking students base...
Slowly Changing Dimensions (SCD) include Type 1, Type 2, and Type 3 dimensions.
Type 1: Overwrite existing data with new data, no history is kept.
Type 2: Create a new record for each change, maintaining history.
Type 3: Create a new attribute to store changes, keeping limited history.
I applied via Naukri.com and was interviewed before Oct 2023. There were 2 interview rounds.
Some tools used for ETL testing include Informatica, Talend, SSIS, and Apache Nifi.
Informatica
Talend
SSIS (SQL Server Integration Services)
Apache Nifi
Advanced SQL techniques for handling large datasets
Use indexing to improve query performance
Optimize queries by avoiding unnecessary joins and subqueries
Utilize partitioning and clustering to manage large tables efficiently
Consider using window functions for complex analytical queries
I applied via Naukri.com and was interviewed before Jun 2023. There were 2 interview rounds.
Multiple choice questions
Union combines and removes duplicates, while union all combines without removing duplicates.
Union removes duplicates from the result set, while union all does not.
Union is slower than union all because it has to perform an additional step to remove duplicates.
Union all is used when duplicates are desired in the result set.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FROM ...
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is unique
It can be a single column or a combination of columns
Primary key values cannot be NULL
I applied via Referral and was interviewed in Sep 2022. There were 4 interview rounds.
Before attending face to face interview we need clear online technical assessment. It's a objective type question mostly questions are related to unix, SQL, data warehousing,abinitio
Union, Union All, and Difference are SQL set operators used to combine or compare data from multiple tables.
Union combines the results of two or more SELECT statements and removes duplicates.
Union All combines the results of two or more SELECT statements and includes duplicates.
Difference (also known as Except) returns only the rows from the first SELECT statement that are not in the second SELECT statement.
All three o...
I applied via Naukri.com and was interviewed in Dec 2021. There were 3 interview rounds.
I applied via Company Website and was interviewed in Jan 2021. There were 3 interview rounds.
I applied via Campus Placement and was interviewed in Sep 2021. There was 1 interview round.
I am currently working on developing a mobile application for a client in the hospitality industry.
The application will allow users to make reservations and order food and drinks from their mobile devices.
We are using React Native for the front-end and Node.js for the back-end.
We are also implementing a payment gateway to allow for secure transactions.
The client has requested that the app be available in both iOS and A...
based on 5 interview experiences
Difficulty level
Duration
based on 10 reviews
Rating in categories
Application Development Analyst
39.3k
salaries
| ₹4.8 L/yr - ₹11 L/yr |
Application Development - Senior Analyst
27.7k
salaries
| ₹8.3 L/yr - ₹16.1 L/yr |
Team Lead
26.5k
salaries
| ₹12.6 L/yr - ₹22.5 L/yr |
Senior Analyst
19.5k
salaries
| ₹9 L/yr - ₹15.7 L/yr |
Senior Software Engineer
18.5k
salaries
| ₹10.4 L/yr - ₹18 L/yr |
TCS
Cognizant
Capgemini
Infosys