Infosys Senior SAP SD Consultant Interview Questions and Answers

I am a recent graduate with a degree in Business Administration and a passion for problem-solving and teamwork.

• Recent graduate with a degree in Business Administration

• Passionate about problem-solving and teamwork

• Strong communication and analytical skills

• Experience in internships and extracurricular activities

I expect the company to provide a supportive and challenging work environment, opportunities for growth and learning, and a strong company culture.

• Supportive and challenging work environment

• Opportunities for growth and learning

• Strong company culture

Yes, I am open to relocating for the right opportunity.

• I am willing to relocate for the right job opportunity

• I have experience moving for previous jobs

• I am excited about the possibility of exploring a new location

I plan to gain experience and expertise in the consulting field, eventually aiming for a leadership role.

• Gain experience and expertise in the consulting field

• Work towards a leadership role

• Continuously learn and develop skills

• Build a strong professional network

• Stay updated with industry trends and advancements

IAM major components are authentication, authorization, and identity management.

• Authentication: verifying the identity of a user or system

• Authorization: granting access to resources based on user roles and permissions

• Identity management: managing user identities and their access to resources

• Examples: Single Sign-On (SSO), Multi-Factor Authentication (MFA), Role-Based Access Control (RBAC)

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

Report managing under CMC involves creating, scheduling, and distributing reports.

• Create reports using CMC's report creation tools

• Schedule reports to run at specific times or intervals

• Distribute reports to specific users or groups

• Monitor report usage and performance

• Customize report templates and layouts

• Examples: Sales reports, financial reports, inventory reports

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.