3i Infotech Software Engineer Interview Questions and Answers

Yes, I actively engage with new technologies daily through various resources and practices to stay updated in the software engineering field.

• I read tech blogs and articles daily, such as Medium and Dev.to, to learn about the latest trends.

• I follow influential tech leaders on Twitter and LinkedIn to gain insights into emerging technologies.

• I participate in online courses on platforms like Coursera and Udemy to enhance m...read more

Types of join in SQL

• Inner join: returns only the matching rows from both tables

• Left join: returns all rows from the left table and matching rows from the right table

• Right join: returns all rows from the right table and matching rows from the left table

• Full outer join: returns all rows from both tables

• Cross join: returns the Cartesian product of both tables

SSIS checkpoint and breakpoint are used for debugging and error handling in SSIS packages.

• Checkpoint saves the package progress and restarts from the last successful checkpoint in case of failure.

• Breakpoint pauses the package execution at a specific point to allow debugging and troubleshooting.

• Both can be set at the package level or individual task level.

• Checkpoint uses a checkpoint file to store the progress informati...read more

Containers in SSIS are used to group related tasks and provide a logical flow for the package.

• Containers can be used to group tasks into a single unit of work

• There are several types of containers in SSIS, including Sequence, For Loop, and Foreach Loop

• Containers can be nested to create complex workflows

• Containers can have precedence constraints to control the order in which tasks are executed

Skip first and last 10 rows in Excel source and send to destination

• Use a library like Apache POI or OpenXML to read and write Excel files

• Identify the range of rows to be skipped using row numbers or cell values

• Copy the remaining rows to a new Excel file or sheet and save it as destination

SQL keys and use of surrogate key

• SQL keys are used to uniquely identify records in a table

• Primary key is a unique identifier for a record

• Foreign key is a reference to a primary key in another table

• Surrogate key is a system-generated unique identifier for a record

• Surrogate keys are useful when there is no natural primary key