Genpact Executive Interview Questions and Answers

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

The question was not provided.

• No question provided.

• Cannot answer without the question.

• Please provide the question.

IFRS has various accounting treatments, such as fair value accounting, impairment accounting, and lease accounting.

• Fair value accounting involves measuring and reporting assets and liabilities at their current market value.

• Impairment accounting involves recognizing a loss in the value of an asset that has decreased in value.

• Lease accounting involves recognizing lease payments as either operating or finance leases.

• IFRS ...read more