SAP BODI Interview Question And Answers:
Q.How does the statement ‘Single point of Integration’ suits the data integrator?
DI combines both batch data movement and management with caching to provide a single data integration platform for information management from any information source and for any information use.
Q. State and explain the key function of data integrator.
Loading data: Loading ERP or Enterprise application data into an operational datastore and update in batch-time
Routing request: Creates information requests to a DW or ERP system using complex rules
Applying transaction: DI can apply data changes in a variety of data formats and any custom format.
Q. State and explain various data integrator components.
Designer: Is development interface that allows creating, testing and manually executing jobs that load a DW. Function performed is data mapping, transformation and control logic.
Repository: Set of tables that hold user-created and predefined system objects, metadata, transformation etc.
Local repository: Used to store definitions of DI obj and source/target metadata.
Central repository: Used to support multi-user development. Provides a shared obj library.
Service: Starts Job Server when the system is restarted.
Component: Job Server:
Includes: Administrator: Includes scheduling, starting& stopping real-time services, managing adapters etc.
Metadata Reporting: Provides browser based reports on Enterprise metadata stored in the DI repository.
Q. Explain the process of running a job from designer.
The Designer tells job server to run the job. The job server then gets the job from associated repository and starts an engine to process the job.
Q. Explain job server and engine.
when jobs are executed, the DI engine starts the data movement engine that integrates data from heterogeneous sources, performs complex data transformations and manages extraction and transactions in the ETL process.