Swatirtha Charitable Trust Quality Head Interview Questions and Answers

Electronics City is a major IT hub in Bangalore, India, housing numerous electronics and IT companies.

• Electronics City is located in Bangalore, Karnataka, India.

• It is spread over an area of 332 acres and is divided into three phases.

• The city is home to many multinational companies, research institutions, and educational institutions.

• Some of the prominent companies in Electronics City include Infosys, Wipro, Hewlett-Pac...read more

The biggest mobile industry in India is Reliance Jio.

• Reliance Jio is the largest mobile network operator in India.

• It has a subscriber base of over 400 million as of 2021.

• Reliance Jio disrupted the Indian telecom market with its affordable data plans and free voice calls.

• It offers high-speed 4G internet services and has expanded into various digital services like JioTV, JioCinema, etc.

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