If you're looking for SAP BODS Interview Questions for Experienced & Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research SAP BODS has a market share of about 5.0%. So, You still have the opportunity to move ahead in your career in SAP BODS. Mindmajix offers advanced SAP BODS Interview Questions 2018 that helps you in cracking your interview & acquire your dream career as SAP BODS Developer.
BusinessObjects Data Services provides a graphical interface that allows you to easily create jobs that extract data from heterogeneous sources, transform that data to meet the business requirements of your organization, and load the data into a single location.
Data Services includes the following standard components:
3. Job Server
5. Access Server
7. Real-time Services
8. Address Server
9. Cleansing Packages, Dictionaries, and Directories
10. Management Console [sociallocker]
Stage data in an operational data store, data warehouse, or data mart.
Update staged data in batch or real-time modes.
Create a single environment for developing, testing, and deploying the entire data integration platform.
Manage a single metadata repository to capture the relationships between different extraction and access methods and provide integrated lineage and impact analysis.
1. A job is the smallest unit of work that you can schedule independently for execution.
2. A workflow defines the decision-making process for executing data flows.
3. Data flows extract, transform, and load data. Everything having to do with data, including reading sources, transforming data, and loading targets occurs inside a data flow.
Job, Workflow, Dataflow.
A transform enables you to control how datasets change in a data flow.
Check out: SAP BODS Tutorials
A script is a single-use object that is used to call functions and assign values in a workflow.
Real-time jobs “extract” data from the body of the real-time message received and from any secondary sources used in the job.
An Embedded Dataflow is a data flow that is called from inside another data flow.
A datastore is a connection to a database.
1. Database Datastores: provide a simple way to import metadata directly from an RDBMS.
2. Application Datastores: let users easily import metadata from most Enterprise Resource Planning (ERP) systems.
3. Adapter Datastores: can provide access to an application’s data and metadata or just metadata.
Remove redundant and obsolete objects from the repository tables.
Data Services also allows you to create a database datastore using Memory as the Database type. Memory Datastores are designed to enhance the processing performance of data flows executing in real-time jobs.
A file format is a set of properties describing the structure of a flat-file (ASCII). File formats describe the metadata structure. File format objects can describe files in:
1. Delimited format — Characters such as commas or tabs separate each field.
2. Fixed width format — The column width is specified by the user.
3. SAP ERP and R/3 format.
AnsThe DataServices repository is a set of tables that holds user-created and predefined system objects, source and target metadata, and transformation rules. There are 3 types of repositories.
1. A local repository
2. A central repository
3. A profiler repository
|Explore SAP BODS Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!|
A Repository is a set of tables that hold system objects, source and target metadata, and transformation rules. A Datastore is an actual connection to a database that holds data.
The parameter is an expression that passes a piece of information to a workflow, data flow, or custom function when it is called in a job. A Variable is a symbolic placeholder for values.[/sociallocker]
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.