Cybage Software Engineer Interview Questions, Process, and Tips

Abstract classes are partially implemented classes while interfaces are fully abstract classes.

• Abstract classes can have both implemented and abstract methods while interfaces can only have abstract methods.

• A class can implement multiple interfaces but can only inherit from one abstract class.

• Abstract classes can have constructors while interfaces cannot.

• Interfaces are used for achieving multiple inheritance in Java.

• Ab...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