EY Global Delivery Services ( EY GDS) Staff Assistant Interview Questions, Process, and Tips

I have worked on various PI adapters including PI JDBC, PI ODBC, PI Web API, and PI AF SDK.

• PI JDBC adapter for connecting to PI data archive using Java

• PI ODBC adapter for connecting to PI data archive using ODBC drivers

• PI Web API adapter for accessing PI data archive through web services

• PI AF SDK adapter for accessing PI Asset Framework data

REST is an architectural style for web services while JDBC adapter is used to connect Java applications to databases.

• REST is stateless and uses HTTP methods to perform CRUD operations on resources

• JDBC adapter is a Java API that provides a standard interface for connecting to relational databases

• JDBC adapter can be used to execute SQL statements and retrieve results from the database

• REST and JDBC adapter can be used tog...read more

In the migration project, I followed a phased approach with thorough planning and testing.

• Conducted a thorough analysis of the existing system and identified potential risks and challenges

• Developed a detailed migration plan with clear timelines and milestones

• Implemented the migration in phases to minimize disruption to business operations

• Conducted extensive testing to ensure data integrity and system functionality

• Provi...read more

To setup connectivity between ECC and SAP PI/PO for inbound and outbound proxy and idoc interface, we need to follow these steps:

• Configure RFC destinations in both systems

• Create logical systems in both systems

• Create partner profiles in both systems

• Configure ports in SAP PI/PO

• Create sender and receiver agreements in SAP PI/PO

• Configure message mappings in SAP PI/PO

• Test the interface using test messages

Remove context deletes a message while collapse context hides it.

• Remove context permanently deletes a message from a conversation.

• Collapse context hides a message and replaces it with a 'show more' button.

• Remove context is irreversible while collapse context can be undone by clicking the 'show more' button.

• Remove context is commonly used in messaging apps while collapse context is used in email clients.

• Remove context c...read more

Copy value function copies a value from one cell to another while use one as many function copies a formula from one cell to multiple cells.

• Copy value function is useful when you want to duplicate a value in another cell without having to manually type it again.

• Use one as many function is useful when you want to apply a formula to multiple cells without having to manually enter it in each cell.

• Copy value function can b...read more

IF is a conditional statement that executes a block of code if a specified condition is true. IFs is the plural form of IF.

• IF is used for a single condition, while IFs is used for multiple conditions.

• IFs can be used with the AND and OR operators to combine multiple conditions.

• Example: IF temperature is greater than 90 degrees, turn on the air conditioning. IFs temperature is greater than 90 degrees AND humidity is grea...read more

Java mapping, XSLT mapping, and UDF are all methods used in data transformation.

• Java mapping is a technique used to transform data between different formats using Java code.

• XSLT mapping is a method used to transform XML documents into other formats using XSLT stylesheets.

• UDF stands for User-Defined Function and is a custom function created by a user to perform specific tasks in data transformation.