Interview Questions.

Question 1. What Are Business Objects?

Answer :

Business Objects are basically called domain items. A domain model shows a hard and fast of domain gadgets and explains how they associated with every different. Hence a business version also will display a hard and fast of area items and will show the connection among them.

Question 2. What Is A Universe?

Answer :

Universe is known as because the semantic layer between the Database and the only who designs inorder to create the items and the training. Universe subsequently will map to the statistics inside the Database.

SAP ABAP Interview Questions
Question 3. What Is An Object?

Answer :

Object is simply an entity. The item is called as the instance of a category.

Question four. What Is Business Objects Repository?

Answer :

The term Business gadgets Repository is the metadata best. Repository might be like a database. Business Object Repository will store business objects like user, records, access styles, get right of entry to permissions. Business gadgets Repository is a centralized concept and a fixed of statistics structures can be saved.

SAP BO Tutorial
Question 5. What Is Domain?

Answer :

Domain is known as as a logical grouping of system tables.

SAP BW Interview Questions
Question 6. How Many Types Of Domain Are There In A Basic Setup?

Answer :

There are usually three kinds of area in a primary setup. They are
1. Secure
2. Universe
three. Document

Question 7. What Is Called A Category?

Answer :

category is called because the grouping of numerous entities.

SAP ABAP Tutorial SAP BPC Interview Questions
Question 8. What Is A Bomain.Key?

Answer :

BOMain. Key is a report that's containing all of the information approximately the repository website .Therefore it's going to contain the whole deal with of the repository protection domain.

Question nine. Can We Have Multiple Domains?

Answer :

Yes. We will have a couple of domains

SAP BODS Interview Questions
Question 10. Which Is The Domain Can't Be Have Multiple?

Answer :

The domain which cannot be having more than one is the safety Domain.

SAP BW Tutorial
Question eleven. When Is The Repository Created?

Answer :

Repository Creation will depend on the version. Repository advent will take place after installing the software program in 5i/6i versions after installing the software program, while inside the Xi version the repository can be created at the time of set up.

SAP BDC Interview Questions
Question 12. How The Access To The Rows Of Database Is Restricted?

Answer :

The regulations also will depend on the Version. In XI version we can be finished this by using the usage of the row-stage safety in the fashion designer module. In 5i/6i model the restrict of the get entry to to the database is performed by means of the manager.

SAP ABAP Interview Questions
Question 13. What Is The Term Object Qualification Referring To?

Answer :

Object qualification is just representing what type of item is that. The three styles of item qualifiers are:
1. Measure
2. Dimension
three. Detailed

SAP BPC Tutorial
Question 14. Which Will The Size Of A Database?

Answer :

The length of a database could be between four and eight Tera Bytes.

Question 15. Which Is A Loop?

Answer :

Loop is circular drift.

SAP BW on HANA Interview Questions
Question 16. How Can We Overcome Loop?

Answer :

Loop may be overcome through Alias and Context.

SAP BODS Tutorial
Question 17. How Is Called As A Join?

Answer :

Join is typically used for linking tables depending upon how the statistics is asked by the user.

Sap Bapi Interview Questions
Question 18. Explain The Different Types Of Joins?

Answer :

Joins are of different kinds. They are
1. Inner join
2. Outer Join
3. Left Join
4. Right Join
five. Full Outer be part of

SAP BW Interview Questions
Question 19. What Are Called Linked Universes?

Answer :

Sometimes the information supplied may be from  exceptional universes and the data in those two universes may be connected by some means. These sorts of universes are referred to as Linked Universes.

SAP BW on HANA Tutorial
Question 20. What Is Called Alerter?

Answer :

Alerter is used to present alert or attention to a block of information through highlighting it.

Sap Business One Interview Questions
Question 21. What Is Called Filters?

Answer :

Filters are used to get essential statistics from a set of facts.

Question 22. What Is Called Breaks?

Answer :

Breaks are used to group the records with out changing whatever inside the format.

Question 23. What Are Called Conditions?

Answer :

situations are used to get some information based totally on sure criteria’s or conditions.

Question 24. What Is The Difference Between Master-element And Breaks?

Answer :

In Breaks commonplace entities will be deleted. In master-detail we are able to claim a sure entity as a grasp to get the detailed statistics or it's going to report in this situation that the table layout is changed.

SAP BPC Interview Questions
Question 25. What Are Metrics?

Answer :

Metrics are a device of parameters .Metrics is a way of quantitative and periodic evaluation of a manner that is to be measured. Metrics are commonly used to song tendencies, productivity.

Question 26. What Is A Set?

Answer :

Set is referred to as as the grouping of some of customers.

Question 27. What Is The Advantage Of Afd?

Answer :

AFD is used to create Dash Boards.

SAP BODS Interview Questions
Question 28. Where Normally Afd's Are Stored?

Answer :

AFDs are generally saved in repository, corporate or non-public.

Question 29. What Is The Source Of Metrics?

Answer :

The source of Metrics is by means of degree items.

Question 30. How Many Analysis Are Used In Business Objects?

Answer :

2 forms of analysis are used in Business Objects. They are
1. Slice-Dice Analysis
2. Drill Analysis

Question 31. What Are The General Issues In Migration Process?

Answer :

The trendy issues in migration system are
1. Alignment
2. Performance

Question 32. What Is Solution For Improving Performance?

Answer :

The fundamental solution for enhancing performance is to utilize the Aggregate tables.

Question 33. Types Of Sap Businessobjects Universe In Sap Businessobjects?

Answer :

Simple SAP Businessobjects universe and complex SAP Businessobjects universe.

SAP BDC Interview Questions
Question 34. What Is The Main Use Of Bca?

Answer :

The important use of BCA is that BCA can be used for refreshing and scheduling and exporting and saving in exclusive layout like .Html, .Rtf, .Xls and .Pdf

Question 35. What Are Called Universal Parameters?

Answer :

RDBMS connection, size rights, Name of the universe, and description are referred to as as the normal Parameters.

Question 36. What Is The Difference Between User And Versatile?

Answer :

SUPERVISOR offers numerous sorts of customers of Business Objects products. The person profile determines by way of default what merchandise a user can use. User profiles can be customized to mirror the needs of the users.

? User (all merchandise but DESIGNER and SUPERVISOR)

? Versatile (configurable)

USERs use the Business Objects give up-person products to query, report, and examine records. They may also use the elective REPORTER and EXPLORER modules for multidimensional evaluation. End customers can produce files containing information from one or greater facts assets.

A versatile person is a custom designed user who can be given get entry to through a manager to any aggregate of Business Objects merchandise.

SAP BW on HANA Interview Questions
Question 37. What Are The User Requirements In This Universe?

Answer :

The person’s necessities on this universe are the Database connections, key column, be a part of and test for loop if you need measures, metrics. The steps to be accompanied must be
1. The connection have to be described.
2. Create the classes and objects
3. Give the joins and then solve the loops.
4. Generate the universe.

Question 38. What Is The Use Of Business Objects Data Services?

Answer :

Business Objects Data Services gives a graphical interface that lets in you to easily create jobs that extract statistics from heterogeneous sources, remodel that information to fulfill the enterprise necessities of your agency, and cargo the facts right into a unmarried area.

Question 39. Define Data Services Components.

Answer :

Data Services consists of the following trendy components:

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

Answer :

 Stage information in an operational datastore, records warehouse, or statistics mart.
 Update staged information in batch or real-time modes.
 Create a single environment for growing, trying out, and deploying the complete facts integration platform.
 Manage a single metadata repository to capture the relationships among one of a kind extraction and get right of entry to methods and provide incorporated lineage and impact evaluation.
Sap Bapi Interview Questions
Question forty one. Define The Terms Job, Workflow, And Dataflow

Answer :

 A task is the smallest unit of work that you may schedule independently for execution.
 A paintings flow defines the selection-making procedure for executing records flows.
 Data flows extract, rework, and load statistics. Everything having to do with facts, consisting of studying assets, remodeling information, and loading targets, takes place inside a information float.
Question 42. Arrange These Objects In Order By Their Hierarchy: Dataflow, Job, Project, And Workflow.

Answer :

Project, Job, Workflow, Dataflow.

Sap Business One Interview Questions
Question 43. What Are Reusable Objects In Dataservices?

Answer :

Job, Workflow, Dataflow.

Question 44. What Is A Transform?

Answer :

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

Question 45. What Is A Script?

Answer :

A script is a unmarried-use item that is used to call capabilities and assign values in a workflow.

Question 46. What Is A Real Time Job?

Answer :

Real-time jobs "extract" information from the frame of the real time message obtained and from any secondary sources used inside the task.

Question forty seven. What Is An Embedded Dataflow?

Answer :

An Embedded Dataflow is a dataflow this is called from inner some other dataflow.

Question forty eight. What Is The Difference Between A Data Store And A Database?

Answer :

A datastore is a connection to a database.

Question 49. How Many Types Of Datastores Are Present In Data Services?

Answer :

Three.

 Database Datastores: offer a easy manner to import metadata directly from RDBMS.
 Application Datastores: permit users easily import metadata from maximum Enterprise Resource Planning (ERP) systems.
 Adapter Datastores: can provide access to an software’s statistics and metadata or just metadata.
Question 50. What Is The Use Of Compact Repository?

Answer :

Remove redundant and obsolete gadgets from the repository tables.

Question fifty one. What Are Memory Datastores?

Answer :

Data Services additionally allows you to create a database datastore the usage of Memory because the Database kind. Memory Datastores are designed to beautify processing overall performance of statistics flows executing in actual-time jobs.

Question fifty two. What Are File Formats?

Answer :

A document format is a fixed of homes describing the shape of a flat record (ASCII). File formats describe the metadata structure. File layout items can describe documents in:

 Delimited format — Characters along with commas or tabs separate each area.
 Fixed width layout — The column width is designated with the aid of the consumer.
 SAP ERP and R/three format.
Question 53. Which Is Not A Datastore Type?

Answer :

File Format

Question fifty four. What Is Repository? List The Types Of Repositories.

Answer :

The Data Services repository is a set of tables that holds user-created and predefined machine gadgets, supply and goal metadata, and transformation regulations. There are 3 sorts of repositories.

 A local repository
 A vital repository
 A profiler repository
Question fifty five. What Is The Difference Between A Repository And A Datastore?

Answer :

A Repository is a fixed of tables that maintain device items, supply and goal metadata, and transformation rules. A Datastore is an actual connection to a database that holds data.

Question fifty six. What Is The Difference Between A Parameter And A Variable?

Answer :

A Parameter is an expression that passes a chunk of statistics to a work glide, data flow or custom function when it's far referred to as in a task. A Variable is a symbolic placeholder for values.

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

Answer :

 When the variable will want to be used a couple of times inside a task.
 When you need to lessen the development time required for passing values between activity additives.
 When you want to create a dependency between job level global variable call and activity additives.
Question 58. What Is Substitution Parameter?

Answer :

The Value that is regular in one environment, however may additionally alternate while a activity is migrated to any other surroundings.

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

Answer :

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

Question 60. 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 unbiased of each different
 Whether or now not the server can manage the processing necessities of flows strolling on the equal time (in parallel)
Question 61. What Does A Lookup Function Do? How Do The Different Variations Of The Lookup Function Differ?

Answer :

All research features go back one row for every row inside the supply. They vary in how they pick out which of several matching rows to return.

Question 62. List The Three Types Of Input Formats Accepted By The Address Cleanse Transform.

Answer :

Discrete, multiline, and hybrid.

Question sixty three. 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 sixty four. What Are Adapters?

Answer :

Adapters are extra Java-based totally programs that can be hooked up at the task server to provide connectivity to other systems which include Salesforce.Com or the JavaMessagingQueue. There is also a SoftwareDevelopment Kit (SDK) to permit customers to create adapters for custom programs.

Question sixty five. 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 sixty six. List The Data Quality Transforms

Answer :

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

Answer :

These are applications that enhance the capacity of Data Cleanse to as it should be process diverse sorts of global statistics through including language-precise reference facts and parsing guidelines.

Question 68. What Is Data Cleanse?

Answer :

The Data Cleanse remodel identifies and isolates precise parts of blended facts, and standardizes your statistics based totally on information saved within the parsing dictionary, enterprise policies described in the rule of thumb document, and expressions defined inside the pattern report.

Question sixty nine. What Is The Difference Between Dictionary And Directory?

Answer :

Directories offer statistics on addresses from postal government. Dictionary files are used to identify, parse, and standardize statistics inclusive of names, titles, and firm information.

Question 70. 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 goal
 Gender Codes advertising and marketing campaigns
 Provide fields for enhancing matching
 Match Standards effects
Question seventy one. 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 family.
 Address Cleanse: Validate cope with facts.
 Match: Find duplicates.
Question 72. Describe When To Use The Usa Regulatory And Global Address Cleanse Transforms.

Answer :

Use the united states Regulatory transform if USPS certification and/or extra options inclusive of DPV and Geocode are required. Global Address Cleanse must be utilized when processing multi-united states statistics.

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

Answer :

The Data Cleanse rework can generate call fit standards and greetings. It also can assign gender codes and prenames such as Mr. And Mrs.

Question seventy four. What Are Name Match Standards And How Are They Used?

Answer :

Name healthy requirements illustrate the a couple of methods a name may be represented. They are used within the healthy system to significantly growth fit results.

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

Answer :

 Using the car-correct load alternative within the target table.
 Including the Table Comparison transform within the information go with the flow.
 Designing the facts flow to completely replace the target desk at some point of every execution.
 Including a preload SQL declaration to execute before the desk loads.
Question 76. What Is The Use Of Auto Correct Load?

Answer :

It does no longer allow duplicated data moving into the target desk.It works like Type 1 Insert else Update the rows based on Non-matching and matching facts respectively.

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

Answer :

Array fetch size suggests the quantity of rows retrieved in a unmarried request to a supply database. The default fee is 1000. Higher numbers reduce requests, reducing network traffic, and possibly enhance overall performance. The maximum cost is 5000

Question seventy eight. What Are The Differences Between Row-through-row Select And Cached Comparison Table And Sorted Input In Table Comparison Transform?

Answer :

 Row-with the aid of-row pick out - look up the target desk using SQL every time it gets an input row. This choice is satisfactory if the goal table is massive.
 Cached contrast table — To load the assessment table into reminiscence. This option is excellent whilst the desk fits into reminiscence and you're evaluating the entire target table
 Sorted enter — To read the assessment desk inside the order of the number one key column(s) the use of sequential read.This choice improves performance due to the fact Data Integrator reads the comparison table only once.Add a question among the supply and the Table_Comparison remodel. Then, from the query’s input schema, drag the primary key columns into the Order By field of the question.
Question 79. What Is The Use Of Using Number Of Loaders In Target Table?

Answer :

Number of loaders loading with one loader is referred to as Single loader Loading. Loading whilst the quantity of loaders is more than one is known as Parallel Loading. The default range of loaders is 1. The most quantity of loaders is 5.

Question eighty. What Is The Use Of Rows Per Commit?

Answer :

Specifies the transaction size in range of rows. If set to 1000, Data Integrator sends a commit to the underlying database every one thousand rows.

Question eighty one. What Is The Difference Between Lookup (), Lookup_ext () And Lookup_seq ()?

Answer :

 research() : Briefly, It returns single cost based totally on single circumstance
 lookup_ext(): It returns more than one values based on unmarried/a couple of condition(s)
 lookup_seq(): It returns more than one values primarily based on sequence range
Question 82. What Is The Use Of History Preserving Transform?

Answer :

The History Preserving rework allows you to provide a brand new row on your target in preference to updating an present row. You can imply in which columns the transform identifies modifications to be preserved. If the fee of certain columns exchange, this remodel creates a new row for each row flagged as UPDATE inside the enter information set.

Question eighty three. What Is The Use Of Map-operation Transform?

Answer :

The Map-Operation remodel permits you to alternate operation codes on data units to provide the preferred output. Operation codes: INSERT, UPDATE, DELETE, NORMAL  or DISCARD.

Question eighty four. What Is Heirarchy Flatenning?

Answer :

Constructs a whole hierarchy from parent/child relationships, and then produces a description of the hierarchy in vertically or horizontally flattened format.

 Parent Column, Child Column
 Parent Attributes, Child Attributes.
Question 85. What Is The Use Of Case Transform?

Answer :

Use of the Case rework is to simplify branch common sense in facts flows with the aid of consolidating case or selection-making logic into one transform. The remodel permits you to cut up a statistics set into smaller sets based totally on logical branches.

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

Answer :

You have to define audit points and audit rules when you want to audit a records flow.

Question 87. List Some Factors For Performance Tuning In Data Services?

Answer :

The following sections describe methods you may regulate Data Integrator overall performance

 Source-primarily based overall performance alternatives
 Using array fetch length
 Caching data
 Join ordering
 Minimizing extracted facts
 Target-primarily based performance alternatives
 Loading approach and rows per commit
 Staging tables to hurry up auto-accurate loads
 Job layout performance alternatives
 Improving throughput
 Maximizing the range of driven-down operations
 Minimizing data type conversion
 Minimizing nearby conversion
 Improving Informix repository overall performance