Infosys Server Administrator Interview Questions and Answers

I know that the company is a leading consulting firm known for its innovative solutions. Regarding compensation, I am aware of the competitive salary and benefits package offered.

• The company is known for its innovative solutions in the consulting industry

• They have a strong reputation for delivering high-quality services to clients

• I am aware that the compensation package includes competitive salary and benefits

• The compa...read more

OLAP in IDT and UDT and generating reports without universe

• OLAP can be used in both IDT and UDT for data analysis

• Reports can be generated without a universe using OLAP

• OLAP allows for multidimensional analysis of data

HANA, ERP, and BW are all data sources that can be used to create reports in BI.

• HANA can be used as a data source for BI reports, allowing for real-time reporting and analysis.

• ERP data can also be used to create BI reports, providing insights into business operations and performance.

• BW is a data warehousing solution that can be used to store and manage data for BI reporting.

• All three data sources can be integrated with...read more

Report customisation can be done by using tools like Crystal Reports or SSRS to modify the layout and data displayed.

• Identify the report to be customised

• Determine the changes to be made

• Use a report customisation tool like Crystal Reports or SSRS

• Modify the layout and data displayed

• Test the customised report to ensure accuracy

Creating a stored procedure for complex reporting involves defining parameters, writing SQL logic, and optimizing performance.

• Define the purpose of the report and the data needed.

• Use CREATE PROCEDURE syntax to start defining the stored procedure.

• Include input parameters for dynamic filtering, e.g., @StartDate, @EndDate.

• Write SQL queries within the procedure to fetch and manipulate data.

• Utilize temporary tables or table...read more

BI reports have filters at both report level and query level.

• Report level filters allow users to filter data within the report itself.

• Query level filters are applied to the underlying data source before the report is generated.

• Common filters include date filters, dimension filters, and measure filters.

• Report level filters can be applied to specific visualizations or the entire report.

• Query level filters can be used to ...read more

There are multiple ways to resolve loops during universe building.

• One way is to use aggregate awareness to avoid loops.

• Another way is to use aliases to create a self-join.

• A third way is to use contexts to define the scope of the query.

• It is also important to ensure that the join paths are correct and optimized.

• Testing and debugging can help identify and resolve any remaining loops.

Yes, I am satisfied with my current salary.

• I am content with my current salary as it meets my financial needs

• I feel valued for my work and contributions at my current salary level

• I have compared my salary with industry standards and feel it is fair

The speed of the person sitting under the train is zero.

• The person sitting under the train is stationary.

• The speed of the train does not affect the speed of the person.

• The person's speed is relative to the ground, not the train.

Water does not fall from a filled glass because of surface tension and gravity.

• Surface tension of water creates a force that holds it together and prevents it from overflowing.

• Gravity pulls the water downwards, keeping it inside the glass.

• The shape of the glass also plays a role in containing the water.

• If the glass is filled beyond its capacity, the surface tension may break and water will overflow.

As a Senior Consultant, my daily deliverables include project management, client communication, team coordination, and report generation.

• Managing projects and ensuring timely delivery

• Communicating with clients to understand their requirements and providing solutions

• Coordinating with team members to ensure smooth workflow

• Generating reports to track progress and identify areas for improvement

BSOD stands for Blue Screen of Death, a critical error screen displayed by Windows operating systems.

• BSOD is a critical error screen displayed by Windows operating systems.

• It is usually caused by hardware or software issues.

• BSOD can be identified by the blue screen with white text and error codes.

• It often requires a system restart to resolve the issue.

• Examples of BSOD error codes include IRQL_NOT_LESS_OR_EQUAL and SYST...read more

Django application flow involves request handling, URL routing, view processing, model interaction, and response rendering.

• Client sends a request to the server.

• URL routing maps the request to a specific view function.

• View function processes the request and interacts with the model layer.

• Model layer interacts with the database and returns data to the view function.

• View function renders the response using templates and r...read more