1. What is the use of BusinessObjects Data Services?

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.

2. Define the terms Job, Workflow, and Dataflow

3. What is a transform?

A transform enables you to control how datasets change in a data flow.

4. What is a real time Job?

Real-time jobs “extract” data from the body of the real-time message received and from any secondary sources used in the job.

5. What are the steps included in Data integration process?

interview questions

6. What are Memory Datastores?

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.

7. Define Data Services components.

Data Services includes the following standard components:

8. When would you use a global variable instead of a local variable?

9. What does a lookup function do? How do the different variations of the lookup function differ?

All lookup functions return one row for each row in the source. They differ in how they choose which of several matching rows to return.

10. What is online and offline mode?

If you want a universe to be accessible in offline mode, you must first ensure that the universe has been opened at least once in online mode and that it has been saved with the Save for All Users check box selected in the Save Universe As box. 

To make Offline mode available:

Mode Description

Online Default mode of operation for Designer when you are working in an environment with a repository.

Offline Mode of operation for Designer when you are not connected to a repository.

• Only available if you have previously connected in online mode.

• In offline mode you can open universes that are stored on your local computer only if those universes have been opened previously in online mode.

11. What are Cleansing Packages?

These are packages that enhance the ability of Data Cleanse to accurately process various forms of global data by including language-specific reference data and parsing rules.

12. How to create hierarchies in BO?

A hierarchy, which the Designer sets up when creating the universe, consists of dimension objects ranked from “less detailed” to “more detailed”. The objects that belong to hierarchies are the ones you can use to define the scope of analysis.

13. What is Data Cleanse?

The Data Cleanse transform identifies and isolates specific parts of mixed data, and standardizes your data based on information stored in the parsing dictionary, business rules defined in the rule file, and expressions defined in the pattern file.


14. What is the difference between Dictionary and Directory?

Directories provide information on addresses from postal authorities. Dictionary files are used to identify, parse, and standardize data such as names, titles, and firm data.

15. What are file formats?

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:

16. Give some examples of how data can be enhanced through the data cleanse transform, and describe the benefit of those enhancements.

17. What are the types of connections we use when connecting to the database?

There are three types of connections namely: – Secured, Shared, and Personal.

A secured connection is used to centralize and control access to sensitive or critical data. It is the safest type of connection for protecting access to data.

A shared connection is used to access common resources such as universes or documents. Several users can thus use it.

A personal connection is specific to one user and can be used only from the computer on which it was created.

18. What is repository? List the types of repositories.

The 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.

19. What are the available memory types in data flows?

1. Pageable

2. In Memory

The software provides the following types of caches that your data flow can use for all of the operations it contains:


Use in-memory cache when your data flow processes a small amount of data that fits in memory.

Pageable cache

Use a pageable cache when your data flow processes a very large amount of data that does not fit in memory.

20. What are the available lookups?

21. What are strategies?

A strategy is a script that automatically extracts structural information from a database or flat file.