Interview Questions.

Question 1. What Is The Use Of Businessobjects Data Services?

Answer :

BusinessObjects Data Services provides a graphical interface that lets in you to without problems create jobs that extract statistics from heterogeneous resources, rework that statistics to meet the business necessities of your business enterprise, and cargo the facts into a unmarried area.

Question 2. Define Data Services Components?

Answer :

Data Services consists of the subsequent general components:

Designer
Repository
Job Server
Engines
Access Server
Adapters
Real-time Services
Address Server
Cleansing Packages, Dictionaries, and Directories
Management Console
SAP BO Interview Questions
Question 3. What Are The Steps Included In Data Integration Process?

Answer :

Stage facts in an operational datastore, records warehouse, or statistics mart.
Update staged records in batch or real-time modes.
Create a single surroundings for developing, testing, and deploying the entire statistics integration platform.
Manage a unmarried metadata repository to capture the relationships among unique extraction and get right of entry to methods and  provide included lineage and impact evaluation.
Question four. Define The Terms Job, Workflow, And Dataflow?

Answer :

A job is the smallest unit of work that you may schedule independently for execution.
A paintings drift defines the decision-making process for executing records flows.
Data flows extract, rework, and load records. Everything having to do with data, which include reading resources, transforming information, and loading targets, happens interior a records go with the flow.
SAP BO Tutorial
Question 5. Arrange These Objects In Order By Their Hierarchy: Dataflow, Job, Project, And Workflow?

Answer :

Project, Job, Workflow, Dataflow.

SAP ABAP Interview Questions
Question 6. What Are Reusable Objects In Dataservices?

Answer :

Job, Workflow, Dataflow.

Question 7. What Is A Transform?

Answer :

A transform enables you to control how datasets alternate in a dataflow.

SAP ABAP Tutorial SAP BW Interview Questions
Question eight. What Is A Script?

Answer :

A script is a unmarried-use item this is used to name functions and assign values in a workflow.

Question 9. What Is A Real Time Job?

Answer :

Real-time jobs “extract” records from the frame of the real time message acquired and from any secondary resources used inside the process.

Data Stage Interview Questions
Question 10. What Is An Embedded Dataflow?

Answer :

An Embedded Dataflow is a dataflow that is called from interior some other dataflow.

SAP BW Tutorial
Question 11. What Is The Difference Between A Data Store And A Database?

Answer :

A datastore is a connection to a database.

SAP BPC Interview Questions
Question 12. How Many Types Of Data Stores Are Present In Data Services?

Answer :

Three.

Database Datastores: offer a simple manner to import metadata immediately from an RDBMS.
Application Datastores: let customers easily import metadata from maximum Enterprise Resource Planning (ERP) structures.
Adapter Datastores: can provide get entry to to an software’s statistics and metadata or just metadata.
SAP BO Interview Questions
Question thirteen. What Is The Use Of Compace Repository?

Answer :

Remove redundant and obsolete gadgets from the repository tables.

SAP BPC Tutorial
Question 14. What Are Memory Datastores?

Answer :

Data Services also lets in you to create a database datastore using Memory because the Database kind. Memory Datastores are designed to beautify processing overall performance of facts flows executing in real-time jobs.

Question 15. What Are File Formats?

Answer :

A document format is a hard and fast of homes describing the structure of a flat document (ASCII). File formats describe the metadata shape.

File format items can describe files in:

Delimited format: Characters inclusive of commas or tabs separate every field.

Fixed width format: The column width is detailed through the person.

SAP ERP and R/three format.

SAP BDC Interview Questions
Question 16. Which Is Not A Data Store Type?

Answer :

File Format

SAP BODS Tutorial
Question 17. What Is Repository? List The Types Of Repositories?

Answer :

The DataServices repository is a set of tables that holds user-created and predefined machine gadgets, supply and goal metadata, and transformation guidelines.

There are three styles of repositories.

A local repository
A vital repository
A profiler repository
SAP BW on HANA Interview Questions
Question 18. What Is The Difference Between A Repository And A Datastore?

Answer :

A Repository is a fixed of tables that hold device gadgets, supply and goal metadata, and transformation policies. A Datastore is an real connection to a database that holds statistics.

SAP ABAP Interview Questions
Question 19. What Is The Difference Between A Parameter And A Variable?

Answer :

A Parameter is an expression that passes a bit of records to a piece glide, records go with the flow or custom function while it is referred to as in a job. A Variable is a symbolic placeholder for values.

SAP BW on HANA Tutorial
Question 20. When Would You Use A Global Variable Instead Of A Local Variable?

Answer :

When the variable will want to be used a couple of instances inside a job.
When you need to lessen the improvement time required for passing values between job components.
When you need to create a dependency between job level global variable call and process additives.
Sap Bapi Interview Questions
Question 21. What Is Substitution Parameter?

Answer :

The Value this is constant in one surroundings, but can also change while a activity is migrated to another environment.

Question 22. List Some Reasons Why A Job Might Fail To Execute?

Answer :

Incorrect syntax, Job Server now not running, port numbers for Designer and Job Server now not matching.

Question 23. List Factors You Consider When Determining Whether To Run Work Flows Or Data Flows Serially Or In Parallel?

Answer :

Consider the following:

Whether or not the flows are independent of every other
Whether or not the server can handle the processing requirements of flows running at the same time (in parallel)
Sap Business One Interview Questions
Question 24. What Does A Lookup Function Do? How Do The Different Variations Of The Lookup Function Differ?

Answer :

All lookup functions return one row for every row within the source. They fluctuate in how they pick out which of several matching rows to return.

SAP BW Interview Questions
Question 25. List The Three Types Of Input Formats Accepted By The Address Cleanse Transform?

Answer :

Discrete, multiline, and hybrid.

Question 26. Name The Transform That You Would Use To Combine Incoming Data Sets To Produce A Single Output Data Set With The Same Schema As The Input Data Sets?

Answer :

The Merge rework.

Question 27. What Are Adapters?

Answer :

Adapters are additional Java-based totally programs that may be installed on the task server to provide connectivity to different systems which includes Salesforce.Com or the JavaMessagingQueue. There is likewise a SoftwareDevelopment Kit (SDK) to permit clients to create adapters for custom applications.

Data Stage Interview Questions
Question 28. List The Data Integrator Transforms?

Answer :

Data_Transfer
Date_Generation
Effective_Date
Hierarchy_Flattening
History_Preserving
Key_Generation
Map_CDC_Operation
Pivot Reverse Pivot
Table_Comparison
XML_Pipeline
Question 29. List The Data Quality Transforms?

Answer :

Global_Address_Cleanse
Data_Cleanse
Match
Associate
Country_id
USA_Regulatory_Address_Cleanse
Question 30. What Are Cleansing Packages?

Answer :

These are programs that decorate the ability of Data Cleanse to accurately method numerous styles of global statistics by way of together with language-precise reference statistics and parsing policies.

Question 31. What Is Data Cleanse?

Answer :

The Data Cleanse remodel identifies and isolates specific elements of blended records, and standardizes your data based on facts saved inside the parsing dictionary, business policies described in the rule report, and expressions defined inside the pattern record.

Question 32. What Is The Difference Between Dictionary And Directory?

Answer :

Directories provide information on addresses from postal government. Dictionary files are used to pick out, parse, and standardize statistics which includes names, titles, and firm facts.

Question 33. Give Some Examples Of How Data Can Be Enhanced Through The Data Cleanse Transform, And Describe The Benefit Of Those Enhancements?

Answer :

Enhancement Benefit
Determine gender distributions and target
Gender Codes advertising and marketing campaigns
Provide fields for enhancing matching
Match Standards consequences
SAP BPC Interview Questions
Question 34. A Project Requires The Parsing Of Names Into Given And Family, Validating Address Information, And Finding Duplicates Across Several Systems. Name The Transforms Needed And The Task They Will Perform?

Answer :

Data Cleanse: Parse names into given and own family.
Address Cleanse: Validate address records.
Match: Find duplicates.
Question 35. Describe When To Use The Usa Regulatory And Global Address Cleanse Transforms?

Answer :

Use the us Regulatory remodel if USPS certification and/or extra options which includes DPV and Geocode are required. Global Address Cleanse ought to be applied whilst processing multi-us of a statistics.

Question 36. Give Two Examples Of How The Data Cleanse Transform Can Enhance (append) Data?

Answer :

The Data Cleanse transform can generate call in shape standards and greetings. It also can assign gender codes and prenames inclusive of Mr. And Mrs.

SAP BDC Interview Questions
Question 37. What Are Name Match Standards And How Are They Used?

Answer :

Name fit standards illustrate the multiple methods a call may be represented.They are used within the suit technique to greatly increase match outcomes.

Question 38. What Are The Different Strategies You Can Use To Avoid Duplicate Rows Of Data When Re-loading A Job?

Answer :

Using the auto-correct load alternative inside the goal table.
Including the Table Comparison transform inside the records go with the flow.
Designing the records go with the flow to completely replace the target table for the duration of every execution.
Including a preload SQL assertion to execute before the table loads.
Question 39. What Is The Use Of Auto Correct Load?

Answer :

It does not permit duplicated information getting into the goal table.It works like Type 1 Insert else Update the rows based on Non-matching and matching information respectively.

Question 40. What Is The Use Of Array Fetch Size?

Answer :

Array fetch size suggests the range of rows retrieved in a single request to a source database. The default value is 1000. Higher numbers lessen requests, reducing network visitors, and probable enhance performance. The most price is 5000.

SAP BW on HANA Interview Questions
Question 41. What Is The Use Of Case Transform?

Answer :

Use the Case remodel to simplify branch common sense in records flows by using consolidating case or choice-making good judgment into one rework. The remodel lets in you to cut up a facts set into smaller units based totally on logical branches.

Question 42. What Must You Define In Order To Audit A Data Flow?

Answer :

You must outline audit factors and audit rules while you need to audit a statistics waft.

Sap Bapi Interview Questions
Question 43. What Is The Difference Between Oltp And A Data Warehouse?

Answer :

Indexes: OLTP device has most effective few indexes even as in an OLAP machine there are many indexes for performance optimization.

Joins: In an OLTP system, big quantity of joins and records is normalized but in an OLAP system there are much less joins and de-normalized.

Aggregation: In an OLTP device records isn't always aggregated even as in an OLAP database greater aggregations are used.

Question forty four. Why Do We Need A Staging Area In An Etl Process?

Answer :

There is a staging place that is required at some point of ETL load.

There are numerous reasons why a staging area is needed:

As source structures are handiest to be had for unique period of time to extract data and this time is less than general statistics load time so Staging region lets in you to extract the information from source gadget and maintain it in staging area earlier than time slot is ended.

Staging area is required whilst you need to get facts from more than one information resources collectively. If you want to join two or extra systems collectively. Example- You will no longer be able to perform a SQL question joining two tables from  bodily distinctive databases.

Data extractions time slot for extraordinary systems vary as in step with the time zone and operational hours.

Data extracted from supply structures may be utilized in a couple of records warehouse device, Operation Data stores, etc.

During ETL you may carry out complex transformations that permits you to carry out complex transformations and require extra place to keep the records.

Question forty five. What Is Sap Data Services?

Answer :

SAP BO Data Services is an ETL tool used for Data integration, facts satisfactory, facts profiling and statistics processing and permits you to combine, transform relied on facts to data warehouse device for analytical reporting.

BO Data Services consists of a UI development interface, metadata repository, records connectivity to source and goal gadget and management console for scheduling of jobs.

Question forty six. What Is A Repository In Bods? What Are The Different Types Of Repositories In Bods?

Answer :

Repository is used to keep meta-statistics of gadgets used in BO Data Services. Each Repository have to be registered in Central Management Console CMC and is linked with single or many job servers which is responsible to execute jobs which are created through you.

There are three varieties of Repositories:

Local Repository:

It is used to save the metadata of all items created in Data Services Designer like mission, jobs, records float, work float, and many others.

Central Repository:

It is used to govern the version management of the items and is used for multiuse improvement. Central Repository shops all the variations of an software item so it lets in you to move to preceding versions.

Profiler Repository:

This is used to manage all of the metadata associated with profiler responsibilities completed in SAP BODS clothier. CMS Repository stores metadata of all of the responsibilities carried out in CMC on BI platform. Information Steward Repository shops all of the metadata of profiling duties and objects created in records steward.

Question 47. What Is Single Object And Reusable Objects In Data Services?

Answer :

Reusable Objects:

Most of the gadgets which are stored in repository may be reused. When a reusable items is defined and shop inside the neighborhood repository, you may reuse the object through growing calls to the definition. Each reusable object has only one definition and all of the calls to that item talk over with that definition. Now if definition of an object is changed at one location you are changing item definition at all the places in which that item appears.

An item library is used to incorporate object definition and whilst an object is drag and drop from library, it way a new reference to an present object is created.

Single Use Objects:

All the items which can be defined specially to a activity or information glide, they're called unmarried use gadgets. Example-specific transformation used in any data load.

Question 48. You Want To Set Up A New Repository In Bods. How Do You Create It?

Answer :

To create BODS Repository you need a database established. You can use SQL Server, Oracle database, My SQL, SAP HANA, Sybase, and many others. You should create under customers in database whilst putting in BODS and to create Repositories. These users are required to login to one-of-a-kind servers CMS Server, Audit Server. To create a new repository, you have to login to Repository manager.

Question forty nine. How Do You Manage Object Versions In Bods?

Answer :

Central repository is used to manipulate the version control of the items and is used for multiuse improvement. Central Repository shops all the versions of an application object so it permits you to move to previous variations.

Question 50. You Want To Generate The Quality Reports In Ds System, Data Validation, And Documentation. Where You Can See This?

Answer :

Data Services Management Console

Question 51. What Is The Template Table?

Answer :

In Data Services, you can create a template table to move to goal machine that has same structure and facts type as source table.

Question 52. How Do You Check The Execution History Of A Job Or A Data Flow?

Answer :

DS Management Console → Job Execution History

Question 53. What Is Sap Data Services Designer? What Are Main Etl Functions That Can Be Performed In Designer Tool?

Answer :

It is a developer tool that's used to create gadgets consist of statistics mapping, transformation, and good judgment. It is GUI based and paintings as clothier for Data Services.

You can create numerous gadgets the usage of Data Services Designer like Project, Jobs, Work Flow, Data Flow, mapping, adjustments, etc.

Question 54. How Do You Check Existing Objects In Ds Repository?

Answer :

In Object library in DS Designer.

Question fifty five. How Do You Improve The Performance Of Data Flows Using Memory Datastore?

Answer :

You can create Datastore using memory as database type. Memory Datastore are used to improve the performance of statistics flows in real time jobs because it shops the records in reminiscence to facilitate quick access and doesn’t require to go to original records supply.

A reminiscence Datastore is used to save reminiscence desk schemas inside the repository. These reminiscence tables get records from tables in Relational database or the use of hierarchical statistics files like XML message and IDocs.

The memory tables stay alive until process executes and statistics in memory tables can’t be shared among specific real time jobs.

Question fifty six. What Is Linked Data Store? Explain With An Example?

Answer :

There are diverse database carriers which handiest offers one way communique route from one database to some other database. These paths are referred to as database links. In SQL Server, Linked server allows one manner communication course from one database to other.

Example:

Consider a local database Server call “Product” stores database hyperlink to get right of entry to information on far off database server known as Customer. Now users that are connected to far flung database server Customer can’t use the identical link to get admission to facts in database server Product. User which are connected to “Customer” should have a separate link in statistics dictionary of the server to access the information in Product database server.

This conversation route between two databases are called database hyperlink and Datastores which are created between these connected database relationships is called related Datastores.

There is a possibility to attach Datastore to some other Datastore and importing an outside database hyperlink as choice of Datastore.

Question 57. You Want To Import Application Metadata Into Repository. How You Can Perform This?

Answer :

Adapter Datastore permits you to import utility metadata into repository. You can also get admission to application metadata and you may also flow batch and real time facts between distinct packages and software program.

Question fifty eight. What Are The Different Types Of Files Can Be Used As Source And Target File Format?

Answer :

Delimited
SAP Transport
Unstructured Text
Unstructured Binary
Fixed Width
Question 59. You Want To Extract Data From An Excel Work Book. How You Can Do This?

Answer :

You can use Microsoft Excel workbook as facts source the use of file codecs in Data Services. Excel work e book should be to be had on Windows file gadget or Unix File machine.

Question 60. What Is The Use Of Data Flow In Ds?

Answer :

Data waft is used to extract, rework and load information from source to goal machine. All the transformations, loading and formatting happens in dataflow.

Question 61. Is It Possible That A Workflow Call Itself In Daa Services Job?

Answer :

Yes

Question sixty two. Give An Example Of Work Flow In Production?

Answer :

There is a fact table that you need to update and you've created a information go with the flow with the transformation. Now If you need to move the records from source gadget, you've got to check final amendment for reality table so you extract simplest rows that has been added after closing update.

In order to achieve this, you need to create one script which determines closing update date after which pass this as enter parameter to statistics flow.

You additionally have to test if information connection to a specific fact desk is lively or no longer. If it isn't always active, you want to setup a catch block which robotically sends an e mail to administrator to inform approximately this hassle.

Question sixty three. What Is The Use Of Conditionals?

Answer :

You also can add Conditionals to workflow. This permits you to put into effect If/Else/Then good judgment on the workflows.

Question 64. What Is A Transformation In Data Services?

Answer :

Transforms are used to manipulate statistics sets as inputs and growing one or a couple of outputs. There are diverse transforms that can be utilized in Data Services.

Question 65. What Are The Common Transformations That Are Available In Data Services?

Answer :

Data Integration
Data Quality
Platform
Merge
Query
Text records processing
Question sixty six. What Is The Use Of Query Transformation?

Answer :

This is maximum commonplace transformation utilized in Data Services and you could perform under functions:

Data filtering from sources
Joining data from more than one resources
Perform capabilities and differences on facts
Column mapping from input to output schemas
Assigning Primary keys
Add new columns, schemas and features resulted to output schemas
As Query transformation is maximum commonly used transformation, so a shortcut is supplied for this query in device palette.
Question 67. What Is An Embedded Data Flow?

Answer :

Embedded statistics drift is known as facts flows that are called from any other information drift in the design. The embedded statistics glide can incorporate a couple of quantity of source and goals however only one enter or output skip statistics to principal information glide.

Question 68. What Are The Different Types Of Embedded Data Flow?

Answer :

One Input: Embedded statistics float is added at the stop of dataflow.

One Output: Embedded statistics glide is added at the beginning of a statistics go with the flow.

No input or output: Replicate an present information flow.

Question sixty nine. Suppose You Have Updated The Version Of Data Services Software? Is It Required To Update The Repository Version?

Answer :

If you update model of SAP Data Services, there may be a need to update version of Repository.

Below points should be considered whilst migrating a primary repository to upgrade version:

Point 1

Take the backup of principal repository all tables and objects.

Point 2

To preserve model of items in statistics services, preserve a crucial repository for every version. Create a new central history with new version of Data Services software and copy all items to this repository.

Point 3

It is constantly endorsed if you install new edition of Data Services, you need to improve your relevant repository to new version of items.

Point 4

Also upgrade your neighborhood repository to same version as one of a kind version of relevant and nearby repository won't paintings on the equal time.

Point five

Before migrating the relevant repository, test in all the objects. As you don’t improve imperative and neighborhood repository concurrently, so there's a want to test in all the items. As once you've got your principal repository upgraded to new version, you will no longer have the ability to check in items from nearby repository that's having older version of Data Services.

Question 70. What Is Slowly Changing Dimension?

Answer :

SCDs are dimensions that have information that adjustments through the years.

Question seventy one. How Do You Manage Slowly Changing Dimensions? What Are The Fields Required In Managing Different Types If Scd?

Answer :

SCD Type 1 No history renovation
Natural outcome of normalization
SCD Type 2 Preserving all records and new rows
There are new rows generated for giant changes
You want to use of a unique key
There are new fields are generated to keep history facts
You need to manage an Effective_Date field.
SCD Type 3 Limited history maintenance
In this best  states of statistics are preserved - present day and antique
Question seventy two. Is File Format In Data Services Type Of A Data Store?

Answer :

No, File format is not a datastore type.