Scribd
Upload
174 views25 pages

PH No:+1-508-841-6144

This document discusses BusinessObjects Data Services, which provides a graphical interface to extract, transform, and load data from heterogeneous sources into a single location. It defines common Data Services components like the Designer, Repository, Job Server, and Engines. It also explains concepts like jobs, workflows, dataflows, transforms, variables, parameters, lookups, and more.

Uploaded by

ACB
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
174 views25 pages

PH No:+1-508-841-6144

This document discusses BusinessObjects Data Services, which provides a graphical interface to extract, transform, and load data from heterogeneous sources into a single location. It defines common Data Services components like the Designer, Repository, Job Server, and Engines. It also explains concepts like jobs, workflows, dataflows, transforms, variables, parameters, lookups, and more.

Uploaded by

ACB
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 25

By

www.Garudatrainings.com
Ph No:+1-508-841-6144
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.
Define Data Services components
 Data Services includes the following standard components:
 Designer
 Repository
 Job Server
 Engines
 Access Server
 Adapters
 Real-time Services
 Address Server
 Cleansing Packages, Dictionaries, and Directories
 Management Console
What are the steps included in Data integration process?

 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.
Define the terms Job, Workflow, and Dataflow?
 A job is the smallest unit of work that you can schedule
independently for execution.
 A work flow defines the decision-making process for
executing data flows.
 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.
 Arrange these objects in order by their hierarchy:
Dataflow, Job, Project, and Workflow.?
 Project, Job, Workflow, Dataflow.
What are reusable objects in Data Services?
 Job, Workflow, Dataflow.
What is a transform?
A transform enables you to control how datasets
change in a dataflow.
What is a Script?
A transform enables you to control how datasets
change in a dataflow.
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.
What is an Embedded Dataflow?
An Embedded Dataflow is a dataflow that is called
from inside another dataflow.
What is the difference between a data store and a
database?
A data store is a connection to a database.
How many types of data stores are present in
Data services?
 Three.
 Database Datastores: provide a simple way to import
metadata directly froman RDBMS.
 Application Datastores: let users easily import
metadata frommost Enterprise Resource Planning
(ERP) systems.
 Adapter Datastores: can provide access to an
application’s data and metadata or just metadata.
What is the use of Compace repository?
Remove redundant and obsolete objects from the
repository tables.
What are Memory Datastores?
Data Services also allows you to create a database data
store using Memory as the Database type. Memory
Data Stores are designed to enhance processing
performance of data flows executing in real-time jobs.
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:
 Delimited format — Characters such as commas or
tabs separate each field.
 Fixed width format — The column width is specified
by the user.
 SAP ERP and R/3 format.
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.
 A local repository
 A central repository
 A profiler repository
What is the difference between a Repository
and a Datastore?
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.
What is the difference between a Parameter
and a Variable?
A Parameter is an expression that passes a piece of
information to a work flow, data flow or custom
function when it is called in a job. A Variable is a
symbolic placeholder for values.
When would you use a global variable instead
of a local variable?
 When the variable will need to be used multiple times
within a job.
 When you want to reduce the development time
required for passing values between job components.
 When you need to create a dependency between job
level global variable name and job components.
What is Substitution Parameter?
The Value that is constant in one environment, but
may change when a job is migrated to another
environment.
List some reasons why a job might fail to
execute?
 Incorrect syntax, Job Server not running, port numbers
for Designer and Job Server not matching.
List factors you consider when determining whether
to run work flows or data flows serially or in parallel?
 Consider the following:
 Whether or not the flows are independent of each
other
 Whether or not the server can handle the processing
requirements of flows running at the same time (in
parallel)
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.
Contact Us:
For More Details, Please Log On To
www.Garudatrainings.com

You Can also Find Us On:


Register For Free Demo
www.Garudatrainings.com
Email Us: [email protected]
Ph No:+1-508-841-6144

You might also like