i
Saksoft
Filter interviews by
I applied via Naukri.com and was interviewed in Oct 2020. There were 3 interview rounds.
Active and Passive transformation in Informatica and SQL query in a project
Active transformation changes the number of rows that pass through it, while passive transformation does not
Active transformation can change the data values, while passive transformation does not
Examples of active transformation include Filter, Router, and Update Strategy, while passive transformation includes Expression and Sequence Generator
SQ...
To delete duplicate records in SQL, use the DISTINCT keyword or GROUP BY clause.
Use the DISTINCT keyword to select unique records and delete the duplicates.
Use the GROUP BY clause to group records by a specific column and delete duplicates within each group.
Use the HAVING clause to filter out groups with more than one record.
Example: DELETE FROM table_name WHERE column_name NOT IN (SELECT MIN(column_name) FROM table_na
I applied via Recruitment Consulltant and was interviewed before Jun 2021. There were 3 interview rounds.
1 hour ,normal coding questions,watch out timelimit
I applied via LinkedIn and was interviewed before Nov 2018. There were 4 interview rounds.
Top trending discussions
The duration of Saksoft interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 29 interviews
Interview experience
based on 345 reviews
Rating in categories
Senior Consultant
353
salaries
| ₹5.5 L/yr - ₹23 L/yr |
Consultant
289
salaries
| ₹3 L/yr - ₹12.3 L/yr |
Lead Consultant
163
salaries
| ₹7.3 L/yr - ₹28 L/yr |
Associate Consultant
97
salaries
| ₹2 L/yr - ₹5.5 L/yr |
Software Engineer
52
salaries
| ₹3.3 L/yr - ₹13.1 L/yr |
TCS
Infosys
Wipro
HCLTech