Filter interviews by
I applied via Approached by Company and was interviewed before Dec 2023. There were 2 interview rounds.
Use SQL query to find duplicate records in a database table
Use GROUP BY clause with COUNT() function to identify duplicate records
Join the table with itself on the columns that need to be checked for duplicates
Filter the results to show only records with count greater than 1
To create a new table from an existing table, you can use the CREATE TABLE AS SELECT statement in SQL.
Use the CREATE TABLE AS SELECT statement in SQL to create a new table based on the structure and data of an existing table.
Specify the columns you want to include in the new table and the source table from which to select the data.
You can also add conditions or filters to the SELECT statement to customize the data bein
Top trending discussions
I applied via Naukri.com and was interviewed in Nov 2020. There were 5 interview rounds.
I applied via Approached by Company and was interviewed before Jul 2021. There was 1 interview round.
I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 5 interview rounds.
Two coding round in Javascript, first one to right CRUD operation in React.
Second one have to right JS for Flattened Array
I applied via Naukri.com and was interviewed before Apr 2023. There were 3 interview rounds.
Singleton class is a class that can only have one instance, while HashMap is not thread-safe but ConcurrentHashMap is.
Singleton class restricts instantiation to one object, ensuring a single instance throughout the application.
HashMap allows multiple threads to access and modify it concurrently, which can lead to data corruption in a multi-threaded environment.
ConcurrentHashMap is thread-safe and allows multiple thread...
I applied via Naukri.com and was interviewed in Jun 2024. There were 3 interview rounds.
To find the second maximum number in a list, sort the list in descending order and return the second element.
Sort the list in descending order
Return the second element in the sorted list
Loops in Informatica are used to iterate over a set of data or perform repetitive tasks.
Loops in Informatica can be implemented using the 'Expression' or 'Router' transformations.
They are useful for processing multiple rows of data in a mapping.
Common types of loops include 'While' and 'For' loops.
Loops can help in performing complex data transformations and validations.
It was medium level question
based on 1 interview
Interview experience
based on 11 reviews
Rating in categories
Software Engineer
101
salaries
| ₹3 L/yr - ₹11.8 L/yr |
Technical Specialist
71
salaries
| ₹6 L/yr - ₹15.5 L/yr |
Technical Analyst
64
salaries
| ₹9 L/yr - ₹17 L/yr |
Senior Technical Analyst
62
salaries
| ₹11.5 L/yr - ₹19.5 L/yr |
Senior Software Engineer
62
salaries
| ₹4.5 L/yr - ₹17.4 L/yr |
ITC Infotech
CMS IT Services
KocharTech
Xoriant