Top Analyst Integration Interview Questions & Answers:

1. Do you know what is White box testing?

White-box testing (also known as clear box testing, glass box testing, transparent box testing, and structural testing) is a method of testing software that tests internal structures or workings of an application, as opposed to its functionality (i.e. black-box testing).

2. Tell us what is Black box testing?

Black-box testing is a method of software testing that examines the functionality of an application without peering into its internal structures or workings. This method of test can be applied to virtually every level of software testing: unit, integration, system and acceptance.

3. What is Data mapping?

In computing and data management, data mapping is the process of creating data element mappings between two distinct data models. Data mapping is used as a first step for a wide variety of data integration tasks including: Data transformation or data mediation between a data source and a destination.

4. Explain what is Data Integration?

► The process of combining data from different resources.
► The combined data is provided to the users with unified view.
► Information from different enterprise domains are integrated - known as Enterprise Information Integration.
► Useful for merging information from different technologies among enterprises.
► The sub areas of data integration are
1. Data Warehousing.
2. Data Migration.
3. Master Data Management.

5. What is Business plan?

A business plan is a formal statement of business goals, reasons they are attainable, and plans for reaching them. It may also contain background information about the organization or team attempting to reach those goals.

6. What are the benefits of data integration?

Following are the benefits of data integration:

► Makes reporting, monitoring, placing customer information across the enterprise flexible and
convenient.
► Data usage is efficient.
► Cost Effective.
► Risk adjusted profitability management as it allows accurate data extraction.
► Allows timely and reliable reporting, as data quality is the prime technology for business challenges.

7. Tell me what is Risk Management?

The identification, analysis, assessment, control, and avoidance, minimization, or elimination of unacceptable risks. An organization may use risk assumption, risk avoidance, risk retention, risk transfer, or any other strategy (or combination of strategies) in proper management of future events.

8. Describe about Physical Data Integration?

► Physical Data Integration is all about creating new system that replicates data from the source systems.
► This process is done to manage the data independent of the original system.
► Data Warehouse is the example of Physical Data Integration.
► The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases.
► A separate system is needed for handling vast data volumes.

9. What is Use Case and Test Case?

Use Case Testing is a functional black box testing technique that helps testers to identify test scenarios that exercise the whole system on each transaction basis from start to finish.

10. Explain about Data Integration hierarchy?

The DI hierarchy is as follows:

► Project->JOB->WorkFlow->DataFlow.
► WorkFlow also has scripts.
► Source, Query, Target are under Data Flow and known as Transformations.
► Workflow, Dataflow, data, files or tables usage for certain number of times, is specified by usage count.
► Objects can be used more than once in Data Integration. These objects are known as reusable objects.