SAP BODS Interview Questions & Answers

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

    Answer :

    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. Question 2. Define Data Services Components?

    Answer :

    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
  3. SAP BO Interview Questions

  4. Question 3. What Are The Steps Included In Data Integration Process?

    Answer :

    1. Stage data in an operational datastore, data warehouse, or data mart.
    2. Update staged data in batch or real-time modes.
    3. Create a single environment for developing, testing, and deploying the entire data integration platform.
    4. Manage a single metadata repository to capture the relationships between different extraction and access methods and  provide integrated lineage and impact analysis.
  5. Question 4. Define The Terms Job, Workflow, And Dataflow?

    Answer :

    1. A job is the smallest unit of work that you can schedule independently for execution.
    2. A work flow 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.
  6. SAP BO Tutorial

  7. Question 5. Arrange These Objects In Order By Their Hierarchy: Dataflow, Job, Project, And Workflow?

    Answer :

    Project, Job, Workflow, Dataflow.

  8. SAP ABAP Interview Questions

  9. Question 6. What Are Reusable Objects In Dataservices?

    Answer :

    Job, Workflow, Dataflow.

  10. Question 7. What Is A Transform?

    Answer :

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

  11. SAP ABAP Tutorial
    SAP BW Interview Questions

  12. Question 8. What Is A Script?

    Answer :

    A script is a single-use object that is used to call functions and assign values in a workflow.

  13. Question 9. What Is A Real Time Job?

    Answer :

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

  14. Data Stage Interview Questions

  15. Question 10. What Is An Embedded Dataflow?

    Answer :

    An Embedded Dataflow is a dataflow that is called from inside another dataflow.

  16. SAP BW Tutorial

  17. Question 11. What Is The Difference Between A Data Store And A Database?

    Answer :

    A datastore is a connection to a database.

  18. SAP BPC Interview Questions

  19. Question 12. How Many Types Of Data Stores Are Present In Data Services?

    Answer :

    Three.

    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.
  20. SAP BO Interview Questions

  21. Question 13. What Is The Use Of Compace Repository?

    Answer :

    Remove redundant and obsolete objects from the repository tables.

  22. SAP BPC Tutorial

  23. Question 14. What Are Memory Datastores?

    Answer :

    Data Services also allows you to create a database datastore using Memory as the Database type. Memory Datastores are designed to enhance processing performance of data flows executing in real-time jobs.

  24. Question 15. What Are File Formats?

    Answer :

    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.

  25. SAP BDC Interview Questions

  26. Question 16. Which Is Not A Data Store Type?

    Answer :

    File Format

  27. SAP BODS Tutorial

  28. 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 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
  29. SAP BW on HANA Interview Questions

  30. Question 18. What Is The Difference Between A Repository And A Datastore?

    Answer :

    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.

  31. SAP ABAP Interview Questions

  32. Question 19. What Is The Difference Between A Parameter And A Variable?

    Answer :

    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.

  33. SAP BW on HANA Tutorial

  34. Question 20. When Would You Use A Global Variable Instead Of A Local Variable?

    Answer :

    • 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.
  35. Sap Bapi Interview Questions

  36. Question 21. What Is Substitution Parameter?

    Answer :

    The Value that is constant in one environment, but may change when a job is migrated to another environment.

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

    Answer :

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

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

    Answer :

    Consider the following:

    1. Whether or not the flows are independent of each other
    2. Whether or not the server can handle the processing requirements of flows running at the same time (in parallel)
  39. Sap Business One Interview Questions

  40. 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 each row in the source. They differ in how they choose which of several matching rows to return.

  41. SAP BW Interview Questions

  42. Question 25. List The Three Types Of Input Formats Accepted By The Address Cleanse Transform?

    Answer :

    Discrete, multiline, and hybrid.

  43. 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 transform.

  44. Question 27. What Are Adapters?

    Answer :

    Adapters are additional Java-based programs that can be installed on the job server to provide connectivity to other systems such as Salesforce.com or the JavaMessagingQueue. There is also a SoftwareDevelopment Kit (SDK) to allow customers to create adapters for custom applications.

  45. Data Stage Interview Questions

  46. Question 28. List The Data Integrator Transforms?

    Answer :

    1. Data_Transfer
    2. Date_Generation
    3. Effective_Date
    4. Hierarchy_Flattening
    5. History_Preserving
    6. Key_Generation
    7. Map_CDC_Operation
    8. Pivot Reverse Pivot
    9. Table_Comparison
    10. XML_Pipeline
  47. Question 29. List The Data Quality Transforms?

    Answer :

    1. Global_Address_Cleanse
    2. Data_Cleanse
    3. Match
    4. Associate
    5. Country_id
    6. USA_Regulatory_Address_Cleanse
  48. Question 30. What Are Cleansing Packages?

    Answer :

    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.

  49. Question 31. What Is Data Cleanse?

    Answer :

    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.

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

    Answer :

    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.

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

    Answer :

    1. Enhancement Benefit
    2. Determine gender distributions and target
    3. Gender Codes marketing campaigns
    4. Provide fields for improving matching
    5. Match Standards results
  52. SAP BPC Interview Questions

  53. 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 :

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

    Answer :

    Use the USA Regulatory transform if USPS certification and/or additional options such as DPV and Geocode are required. Global Address Cleanse should be utilized when processing multi-country data.

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

    Answer :

    The Data Cleanse transform can generate name match standards and greetings. It can also assign gender codes and prenames such as Mr. and Mrs.

  56. SAP BDC Interview Questions

  57. Question 37. What Are Name Match Standards And How Are They Used?

    Answer :

    Name match standards illustrate the multiple ways a name can be represented.They are used in the match process to greatly increase match results.

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

    Answer :

    1. Using the auto-correct load option in the target table.
    2. Including the Table Comparison transform in the data flow.
    3. Designing the data flow to completely replace the target table during each execution.
    4. Including a preload SQL statement to execute before the table loads.
  59. Question 39. What Is The Use Of Auto Correct Load?

    Answer :

    It does not allow duplicated data entering into the target table.It works like Type 1 Insert else Update the rows based on Non-matching and matching data respectively.

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

    Answer :

    Array fetch size indicates the number of rows retrieved in a single request to a source database. The default value is 1000. Higher numbers reduce requests, lowering network traffic, and possibly improve performance. The maximum value is 5000.

  61. SAP BW on HANA Interview Questions

  62. Question 41. What Is The Use Of Case Transform?

    Answer :

    Use the Case transform to simplify branch logic in data flows by consolidating case or decision-making logic into one transform. The transform allows you to split a data set into smaller sets based on logical branches.

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

    Answer :

    You must define audit points and audit rules when you want to audit a data flow.

  64. Sap Bapi Interview Questions

  65. Question 43. What Is The Difference Between Oltp And A Data Warehouse?

    Answer :

    Indexes: OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization.

    Joins: In an OLTP system, large number of joins and data is normalized however in an OLAP system there are less joins and de-normalized.

    Aggregation: In an OLTP system data is not aggregated while in an OLAP database more aggregations are used.

  66. Question 44. Why Do We Need A Staging Area In An Etl Process?

    Answer :

    There is a staging area that is required during ETL load.

    There are various reasons why a staging area is required:

    As source systems are only available for specific period of time to extract data and this time is less than total data load time so Staging area allows you to extract the data from source system and keep it in staging area before time slot is ended.

    Staging area is required when you want to get data from multiple data sources together. If you want to join two or more systems together. Example- You will not be able to perform a SQL query joining two tables from two physically different databases.

    Data extractions time slot for different systems vary as per the time zone and operational hours.

    Data extracted from source systems can be used in multiple data warehouse system, Operation Data stores, etc.

    During ETL you can perform complex transformations that allows you to perform complex transformations and require extra area to store the data.

  67. Question 45. What Is Sap Data Services?

    Answer :

    SAP BO Data Services is an ETL tool used for Data integration, data quality, data profiling and data processing and allows you to integrate, transform trusted data to data warehouse system for analytical reporting.

    BO Data Services consists of a UI development interface, metadata repository, data connectivity to source and target system and management console for scheduling of jobs.

  68. Question 46. What Is A Repository In Bods? What Are The Different Types Of Repositories In Bods?

    Answer :

    Repository is used to store meta-data of objects used in BO Data Services. Each Repository should be registered in Central Management Console CMC and is linked with single or many job servers which is responsible to execute jobs that are created by you.

    There are three types of Repositories:

    Local Repository:

    It is used to store the metadata of all objects created in Data Services Designer like project, jobs, data flow, work flow, etc.

    Central Repository:

    It is used to control the version management of the objects and is used for multiuse development. Central Repository stores all the versions of an application object so it allows you to move to previous versions.

    Profiler Repository:

    This is used to manage all the metadata related to profiler tasks performed in SAP BODS designer. CMS Repository stores metadata of all the tasks performed in CMC on BI platform. Information Steward Repository stores all the metadata of profiling tasks and objects created in information steward.

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

    Answer :

    Reusable Objects:

    Most of the objects that are stored in repository can be reused. When a reusable objects is defined and save in the local repository, you can reuse the object by creating calls to the definition. Each reusable object has only one definition and all the calls to that object refer to that definition. Now if definition of an object is changed at one place you are changing object definition at all the places where that object appears.

    An object library is used to contain object definition and when an object is drag and drop from library, it means a new reference to an existing object is created.

    Single Use Objects:

    All the objects that are defined specifically to a job or data flow, they are called single use objects. Example-specific transformation used in any data load.

  70. 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 installed. You can use SQL Server, Oracle database, My SQL, SAP HANA, Sybase, etc. You have to create below users in database while installing BODS and to create Repositories. These users are required to login to different servers CMS Server, Audit Server. To create a new repository, you have to login to Repository manager.

  71. Question 49. How Do You Manage Object Versions In Bods?

    Answer :

    Central repository is used to control the version management of the objects and is used for multiuse development. Central Repository stores all the versions of an application object so it allows you to move to previous versions.

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

  73. Question 51. What Is The Template Table?

    Answer :

    In Data Services, you can create a template table to move to target system that has same structure and data type as source table.

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

    Answer :

    DS Management Console → Job Execution History

  75. 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 which is used to create objects consist of data mapping, transformation, and logic. It is GUI based and work as designer for Data Services.

    You can create various objects using Data Services Designer like Project, Jobs, Work Flow, Data Flow, mapping, transformations, etc.

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

    Answer :

    In Object library in DS Designer.

  77. Question 55. 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 data flows in real time jobs as it stores the data in memory to facilitate quick access and doesn’t require to go to original data source.

    A memory Datastore is used to store memory table schemas in the repository. These memory tables get data from tables in Relational database or using hierarchical data files like XML message and IDocs.

    The memory tables remain alive till job executes and data in memory tables can’t be shared between different real time jobs.

  78. Question 56. What Is Linked Data Store? Explain With An Example?

    Answer :

    There are various database vendors which only provides one way communication path from one database to another database. These paths are known as database links. In SQL Server, Linked server allows one way communication path from one database to other.

    Example:

    Consider a local database Server name “Product” stores database link to access information on remote database server called Customer. Now users that are connected to remote database server Customer can’t use the same link to access data in database server Product. User that are connected to “Customer” should have a separate link in data dictionary of the server to access the data in Product database server.

    This communication path between two databases are called database link and Datastores which are created between these linked database relationships is known as linked Datastores.

    There is a possibility to connect Datastore to another Datastore and importing an external database link as option of Datastore.

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

    Answer :

    Adapter Datastore allows you to import application metadata into repository. You can also access application metadata and you can also move batch and real time data between different applications and software.

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

    Answer :

    1. Delimited
    2. SAP Transport
    3. Unstructured Text
    4. Unstructured Binary
    5. Fixed Width
  81. 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 data source using file formats in Data Services. Excel work book should be available on Windows file system or Unix File system.

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

    Answer :

    Data flow is used to extract, transform and load data from source to target system. All the transformations, loading and formatting occurs in dataflow.

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

    Answer :

    Yes

  84. Question 62. Give An Example Of Work Flow In Production?

    Answer :

    There is a fact table that you want to update and you have created a data flow with the transformation. Now If you want to move the data from source system, you have to check last modification for fact table so that you extract only rows that has been added after last update.

    In order to achieve this, you have to create one script which determines last update date and then pass this as input parameter to data flow.

    You also have to check if data connection to a particular fact table is active or not. If it is not active, you need to setup a catch block which automatically sends an email to administrator to notify about this problem.

  85. Question 63. What Is The Use Of Conditionals?

    Answer :

    You can also add Conditionals to workflow. This allows you to implement If/Else/Then logic on the workflows.

  86. Question 64. What Is A Transformation In Data Services?

    Answer :

    Transforms are used to manipulate data sets as inputs and creating one or multiple outputs. There are various transforms that can be used in Data Services.

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

    Answer :

    • Data Integration
    • Data Quality
    • Platform
    • Merge
    • Query
    • Text data processing
  88. Question 66. What Is The Use Of Query Transformation?

    Answer :

    This is most common transformation used in Data Services and you can perform below functions:

    1. Data filtering from sources
    2. Joining data from multiple sources
    3. Perform functions and transformations on data
    4. Column mapping from input to output schemas
    5. Assigning Primary keys
    6. Add new columns, schemas and functions resulted to output schemas
    7. As Query transformation is most commonly used transformation, so a shortcut is provided for this query in tool palette.
  89. Question 67. What Is An Embedded Data Flow?

    Answer :

    Embedded data flow is known as data flows which are called from another data flow in the design. The embedded data flow can contain multiple number of source and targets but only one input or output pass data to main data flow.

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

    Answer :

    One Input: Embedded data flow is added at the end of dataflow.

    One Output: Embedded data flow is added at the beginning of a data flow.

    No input or output: Replicate an existing data flow.

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

    Answer :

    If you update version of SAP Data Services, there is a need to update version of Repository.

    Below points should be considered when migrating a central repository to upgrade version:

    Point 1

    Take the backup of central repository all tables and objects.

    Point 2

    To maintain version of objects in data services, maintain a central repository for each version. Create a new central history with new version of Data Services software and copy all objects to this repository.

    Point 3

    It is always recommended if you install new version of Data Services, you should upgrade your central repository to new version of objects.

    Point 4

    Also upgrade your local repository to same version as different version of central and local repository may not work at the same time.

    Point 5

    Before migrating the central repository, check in all the objects. As you don’t upgrade central and local repository simultaneously, so there is a need to check in all the objects. As once you have your central repository upgraded to new version, you will not be able to check in objects from local repository which is having older version of Data Services.

  92. Question 70. What Is Slowly Changing Dimension?

    Answer :

    SCDs are dimensions that have data that changes over time.

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

    Answer :

    1. SCD Type 1 No history preservation
    2. Natural consequence of normalization
    3. SCD Type 2 Preserving all history and new rows
    4. There are new rows generated for significant changes
    5. You need to use of a unique key
    6. There are new fields are generated to store history data
    7. You need to manage an Effective_Date field.
    8. SCD Type 3 Limited history preservation
    9. In this only two states of data are preserved – current and old
  94. Question 72. Is File Format In Data Services Type Of A Data Store?

    Answer :

    No, File format is not a datastore type.