20+ Pipeline Infrastructure Interview Questions and Answers

STO process is a Stock Transport Order process used to transfer goods between plants in different locations.

• STO process involves creating a purchase order (PO) with document type UB.

• The delivering plant creates a delivery document and the receiving plant creates a goods receipt document.

• If a PO with document type NB is an STO, it means that it is not an STO but a standard PO for external procurement.

• The document type NB is used for standard POs while UB is used for STOs.

Use logical path to send IDOC flat file to application layer

• Define logical path in SAP system using transaction code FILE

• Assign logical path to a physical directory where the IDOC flat file is stored

• Use program RSEOUT00 to send the IDOC flat file to the application layer

ALV report can be programmed to react to change data automatically by using event handling and field symbols.

• Use event handling to capture data change events

• Utilize field symbols to dynamically react to changed data

• Implement logic to update ALV display based on changed data

CHARM in Solution Manager is a Change Request Management tool used for managing changes in SAP systems. Retrofit in transport process is the process of applying changes made in a higher system to a lower system.

• CHARM (Change Request Management) in Solution Manager helps in managing changes in SAP systems through a structured process.

• Retrofit in transport process involves applying changes made in a higher system (like development or quality) to a lower system (like production)...read more

Classic BADI is older and uses the CALL CUSTOMER FUNCTION syntax, while Kernel BADI is newer and uses the CALL METHOD syntax. Enhancement sections and points are used to define where enhancements can be implemented in the code.

• Classic BADI uses CALL CUSTOMER FUNCTION, Kernel BADI uses CALL METHOD

• Enhancement sections and points define where enhancements can be implemented

• Examples of enhancement sections are 'BEGIN OF' and 'END OF'

• Examples of enhancement points are 'BEFORE', 'A...read more

Metrics for regression include Mean Squared Error, R-squared, and Mean Absolute Error. For classification, metrics include Accuracy, Precision, Recall, and F1 Score.

• Regression metrics: Mean Squared Error, R-squared, Mean Absolute Error

• Classification metrics: Accuracy, Precision, Recall, F1 Score

The annotation to expose CDS view in analytics is @Analytics.query: true.

• Use @Analytics.query: true annotation in the CDS view definition

• This annotation allows the CDS view to be exposed in analytics tools

Setting up release/pricing procedure involves defining pricing strategy, creating release schedule, and implementing pricing changes.

• Define pricing strategy based on market research and competition analysis

• Create release schedule with clear timelines and milestones

• Implement pricing changes with proper communication to customers and stakeholders

• Regularly review and adjust pricing strategy based on market trends and customer feedback

• Consider factors such as production costs, pr...read more

Types of associations in CDS view include Association, Composition, and Aggregation.

• Association: Represents a relationship between two entities where both entities can exist independently.

• Composition: Represents a strong relationship where the child entity cannot exist without the parent entity.

• Aggregation: Represents a relationship where the child entity can exist independently but is part of a larger whole.

• Example: Association between Customer and Order entities in a sales ...read more

ConcurrentHashMap is a thread-safe version of HashMap in Java, allowing multiple threads to access and modify the map concurrently.

• ConcurrentHashMap uses a technique called 'lock striping' to divide the map into segments, each with its own lock to allow multiple threads to access different segments concurrently.

• It provides better performance than synchronized HashMap by allowing multiple threads to read and write to the map without blocking each other.

• ConcurrentHashMap does n...read more

Concurrency in Java allows multiple tasks to run simultaneously, improving performance and responsiveness.

• Types of concurrency in Java include multithreading, parallelism, and asynchronous programming.

• Multithreading involves multiple threads executing tasks concurrently within a single process.

• Parallelism involves executing multiple tasks simultaneously across multiple processors or cores.

• Asynchronous programming allows tasks to run independently of the main program flow, imp...read more

Use Apex for complex business logic and customization, configuration for simple changes.

• Use Apex for complex business logic that cannot be achieved through configuration

• Configuration is preferred for simple changes that can be easily done through point-and-click tools

• Consider performance implications when deciding between Apex and configuration

• Use configuration for declarative features like workflows, validation rules, and process builder

• Apex is necessary for custom developme...read more

The last CTC was $80,000 and the expected CTC is $90,000.

• Last CTC was $80,000

• Expected CTC is $90,000

Diamond problem in C++ occurs when a class inherits from two classes that have a common base class, leading to ambiguity in method resolution.

• Diamond problem arises in multiple inheritance scenarios in C++

• It occurs when a class inherits from two classes that have a common base class

• This leads to ambiguity in method resolution as the derived class may have multiple implementations of the same method

• To resolve the diamond problem, virtual inheritance can be used to ensure only ...read more

Snowflake follows a multi-cluster, shared data architecture with separate compute and storage layers.

• Snowflake has a central data repository where all data is stored in a columnar format

• It uses virtual warehouses to separate compute resources from storage, allowing for independent scaling

• Data is stored in multiple micro-partitions, enabling efficient data retrieval and processing

• Snowflake's architecture supports automatic scaling and concurrency for high performance

Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.

• Data warehousing involves extracting data from multiple sources and consolidating it into a central repository.

• It is used for analyzing historical data to make informed business decisions.

• Data warehousing helps in creating a single source of truth for an organization's data.

• Examples of data warehousing tools include Amazon Redshift, Snowflake, and Microsof...read more

To re-trigger/debug outbound IDOC, use transaction code BD87 in SAP system.

• Go to transaction code BD87 in SAP system

• Enter the IDOC number and execute

• Check the status and error messages for debugging

• If needed, reprocess the IDOC

SOLID principles are a set of five design principles in object-oriented programming to make software designs more understandable, flexible, and maintainable.

• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open/Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Objects of a superclass should be replaceable with objects of its subclasses without affecting the func...read more

Machine Learning is a subset of artificial intelligence that involves developing algorithms and models that enable computers to learn from and make predictions or decisions based on data.

• Uses algorithms to analyze data, learn from it, and make predictions or decisions

• Examples include recommendation systems, image recognition, and natural language processing

• Involves training models on labeled data to make predictions on new, unseen data

Optimization techniques in Spark and SQL involve partitioning, caching, and using appropriate join strategies.

• Partitioning data to distribute workload evenly

• Caching frequently accessed data to avoid recomputation

• Using appropriate join strategies like broadcast join for small tables

• Avoiding shuffling operations as much as possible

Role Change Concept from scratch

• Understand the current roles and responsibilities

• Identify the gaps and areas of improvement

• Define the new roles and responsibilities

• Communicate the changes clearly to the team

• Provide training and support for the new roles

• Monitor and evaluate the effectiveness of the changes

Dependency injection is a design pattern in which components are given their dependencies rather than creating them internally.

• Dependency injection helps in achieving loose coupling between classes.

• It allows for easier testing and maintenance of code.

• There are three types of dependency injection: constructor injection, setter injection, and interface injection.

Lotus Notes migration tools used

• Quest NME

• Binary Tree

• Transend Migrator

• AvePoint

• SysTools Lotus Notes to Outlook Converter

Abstract class is a class that cannot be instantiated and may contain abstract methods that must be implemented by subclasses.

• Cannot be instantiated directly

• May contain abstract methods that must be implemented by subclasses

• Can have both abstract and non-abstract methods

• Used to define a common interface for subclasses

Magic commands in Databricks are special commands that provide shortcuts for common tasks and operations.

• Magic commands start with % or %% and are used to perform specific actions in Databricks notebooks.

• Examples include %fs for interacting with the file system, %sql for running SQL queries, and %python for executing Python code.

• Magic commands can also be used to manage clusters, install libraries, and display visualizations.

Flows in programming refer to the sequence of steps executed in a program. Inheritance allows a class to inherit properties and methods from another class.

• Types of flows include linear flow, branching flow, and looping flow.

• Inheritance in object-oriented programming allows a subclass to inherit properties and methods from a superclass.

• Example: Linear flow executes steps in a sequential order, branching flow involves decision-making based on conditions, and looping flow repeat...read more

Flow use cases are scenarios where a process or system is executed in a specific sequence to achieve a desired outcome.

• Flow use cases help to visualize the steps and interactions involved in a process.

• Examples include user registration flow on a website, order processing flow in an e-commerce platform, and approval workflow in a business application.