Capgemini Interview Questions, Process, and Tips

Waterfall is a linear sequential approach to software development.

• Divided into distinct phases

• Each phase must be completed before moving to the next

• Emphasis on planning and documentation

• Limited customer involvement until the end

• Difficult to make changes once a phase is completed

To convert rows to columns, use the PIVOT function in SQL.

• Identify the column that will become the new row headers.

• Use the PIVOT function to transform the data.

• Specify the values to be aggregated in the new columns.

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR row_header_column IN (column1, column2, column3))

• Example: Use the UNPIVOT function to convert columns to rows.

A stage in IBM InfoSphere DataStage used to generate rows based on specified criteria.

• Used to create new rows in a data set based on certain conditions

• Can be used to generate test data or to fill in missing data

• Can be configured to generate a specific number of rows or to continue generating rows until a certain condition is met