20+ Anish Polymech Industries Interview Questions and Answers

Integration Runtime (IR) is a compute infrastructure that provides data integration capabilities across different network environments.

• IR is used in Azure Data Factory to provide data integration capabilities

• There are three types of IR: Azure, Self-hosted, and Azure-SSIS

• Azure IR is fully managed by Microsoft and is used for data movement in the cloud

• Self-hosted IR allows data movement between on-premises and cloud data stores

• Azure-SSIS IR is used for running SQL Server Integr...read more

Incremental load in ADF and SSIS involves identifying new or updated data and loading only those changes.

• In ADF, use watermark columns to track the last loaded value and filter data based on this value

• In SSIS, use CDC (Change Data Capture) components or custom scripts to identify new or updated data

• Both ADF and SSIS support incremental loading by comparing source and target data to determine changes

To insert non-duplicate data into a target table, you can use methods like using a unique constraint, using a merge statement, or using a temporary table.

• Use a unique constraint on the target table to prevent duplicate entries.

• Use a merge statement to insert data into the target table only if it does not already exist.

• Use a temporary table to store the new data, then insert only the non-duplicate records into the target table.

To perform a full load in SSIS, you can use the Data Flow Task with a source and destination component.

• Create a Data Flow Task in the Control Flow tab of the SSIS package.

• Add a source component to extract data from the source system.

• Add a destination component to load data into the destination system.

• Map the columns from the source to the destination.

• Run the package to execute the full load.

Use a single activity with dynamic parameterization and loops to copy data.

• Use a loop to iterate through the data source and destination locations.

• Parameterize the source and destination locations to dynamically copy data.

• Utilize a scripting language like Python or PowerShell to implement the logic.

• Example: Use a Python script with a loop to copy files from one folder to another.

• Example: Use PowerShell script with dynamic parameters to copy data from one database to another.

Identifying long running queries in SQL

• Monitor query execution times using tools like SQL Server Profiler or Performance Monitor

• Check system views like sys.dm_exec_requests or sys.dm_exec_query_stats for query durations

• Use query hints like OPTION (RECOMPILE) to force recompilation of queries for better performance

The tcode for item category determination in SAP SD is VOV4.

• Item category determination is used to determine the item category for a sales document item based on various criteria.

• The tcode VOV4 is used to configure the item category determination in SAP SD.

• It allows defining rules and conditions to determine the item category based on material type, item category group, sales document type, etc.

• For example, if a material belongs to a specific material type and the sales docum...read more

Window functions in SQL are used to perform calculations across a set of table rows related to the current row.

• Window functions are used to calculate values based on a set of rows related to the current row.

• They allow for ranking, aggregation, and other calculations within a specific window of rows.

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and SUM() OVER().

Delete removes rows one by one and can be rolled back, while Truncate removes all rows at once and cannot be rolled back.

• Delete is a DML command, while Truncate is a DDL command.

• Delete can be rolled back using a transaction, while Truncate cannot be rolled back.

• Delete fires triggers on each row deletion, while Truncate does not fire triggers.

• Delete is slower as it removes rows one by one, while Truncate is faster as it removes all rows at once.

• Delete maintains the table struc...read more

I played a key role in the implementation project as an SAP SD Consultant.

• I analyzed business requirements and designed solutions.

• I configured the SAP SD module to meet business needs.

• I conducted testing and provided end-user training.

• I collaborated with cross-functional teams to ensure successful project delivery.

• I provided post-implementation support and resolved issues.

• I documented processes and procedures for future reference.

Snowflake is a cloud-based data warehousing platform that allows for easy and scalable data storage and analysis.

• Snowflake is a fully managed service that works on a pay-as-you-go model.

• It separates storage and compute resources, allowing for better scalability and cost-effectiveness.

• Snowflake supports SQL queries and has built-in support for semi-structured data like JSON and XML.

• It provides features like automatic scaling, data sharing, and data replication for high availab...read more

To drive sales at Infovision, I plan to implement various lead generation strategies and focus on building strong customer relationships.

• Implement targeted digital marketing campaigns to reach potential customers

• Offer promotions and discounts to incentivize purchases

• Develop referral programs to encourage current customers to refer new business

• Attend industry events and conferences to network and generate leads

• Invest in customer relationship management software to track and nu...read more

Linked Service connects to external data sources, while Dataset represents the data within the data store.

• Linked Service is used to connect to external data sources like databases, APIs, and file systems.

• Dataset represents the data within the data store and can be used for data processing and analysis.

• Linked Service defines the connection information and credentials needed to access external data sources.

• Dataset defines the schema and structure of the data stored within the d...read more

The preferable locator for dynamic elements is XPath.

• XPath is more powerful and flexible compared to other locators like ID or class name

• XPath can locate elements based on their attributes, position, text, etc.

• Using XPath allows for more precise and reliable element identification

Hooks are functions that let you use state and other React features in functional components. Custom hooks are reusable logic functions created by developers.

• Types of hooks: useState, useEffect, useContext, useReducer, useCallback, useMemo, useRef, useImperativeHandle, useLayoutEffect, useDebugValue

• Custom hooks are used to extract and reuse logic from components, making code more modular and easier to maintain

• Custom hooks can be used to share logic between components, handle ...read more

ASAP Methodology is a framework for SAP implementation projects.

• ASAP stands for Accelerated SAP.

• It is a step-by-step approach to implement SAP solutions.

• It includes five phases: Project Preparation, Business Blueprint, Realization, Final Preparation, and Go-Live and Support.

• Each phase has specific deliverables and tasks to be completed.

• It helps to ensure that the project is completed on time, within budget, and meets the business requirements.

• ASAP Methodology is widely used i...read more

I am very familiar with Java and have extensive experience working with it.

• I have been using Java for over 5 years

• I have developed multiple applications using Java

• I am proficient in Java frameworks such as Spring and Hibernate

• I have experience with Java-based web development using technologies such as JSP and Servlets

WebDriver driver = new ChromeDriver() initializes a new instance of ChromeDriver for controlling the Chrome browser.

• WebDriver is an interface in Selenium used to interact with web browsers

• ChromeDriver is a class that implements the WebDriver interface for controlling Chrome browser

• The 'new' keyword is used to create a new instance of the ChromeDriver class

Poker points are provided based on the player's performance and ranking in the game.

• Poker points are calculated using a formula that takes into account the player's finishing position, the number of players in the game, and the buy-in amount.

• The higher the player's finishing position, the more poker points they will receive.

• Poker points can be used to track a player's progress and skill level over time.

• Poker points can also be used to determine eligibility for certain tournam...read more

BOM stands for Bill of Materials, which is a list of all the components required to manufacture a product.

• BOM is used in manufacturing and production planning.

• It includes information about the quantity, unit of measure, and description of each component.

• BOM can be single-level or multi-level, depending on the complexity of the product.

• It helps in determining the cost of production and managing inventory levels.

• Example: A BOM for a bicycle would include components like frame, ...read more

Listeners in TestNG are used to generate logs or reports during test execution.

• Listeners in TestNG are interfaces that allow customizing test execution logs and reports.

• They can be used to perform actions before or after test methods, suites, classes, etc.

• Examples of listeners in TestNG include ITestListener, IInvokedMethodListener, and IReporter.

Mirror binary tree without recursion by swapping left and right child nodes iteratively

• Start with the root node and swap its left and right child nodes

• Then move to the left child node and swap its left and right child nodes

• Repeat the process for all nodes in the tree until all nodes are mirrored

Relative xpath syntax is used to locate elements based on their relationship to other elements in the HTML structure.

• Start with a double forward slash (//)

• Use the tag name of the element you want to locate

• Add square brackets with the attribute and value you want to match

Steps for an ABAP person in upgrade

• Analyze the current system and identify the areas that need to be upgraded

• Check for compatibility issues with the new version

• Create a backup of the current system

• Install the new version of SAP and perform necessary configurations

• Test the upgraded system and fix any issues

• Train the end-users on the new features and functionalities