Interview Questions.

Q1. What Are Adapters?

Adapters are additional Java-primarily based applications that can be established on the task server to provide connectivity to different systems along with Salesforce.Com or the JavaMessagingQueue. There is also a SoftwareDevelopment Kit (SDK) to allow clients to create adapters for custom packages.

Q2. What Is The Use Of Data Flow In Ds?

Data waft is used to extract, remodel and cargo statistics from supply to goal device. All the changes, loading and formatting happens in dataflow.

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

Data Services Management Console

Q4. List The Three Types Of Input Formats Accepted By The Address Cleanse Transform?

Discrete, multiline, and hybrid.

Q5. What Is The Difference Between A Parameter And A Variable?

A Parameter is an expression that passes a chunk of information to a piece flow, records waft or custom characteristic when it's miles known as in a task. A Variable is a symbolic placeholder for values.

Q6. You Want To Extract Data From An Excel Work Book. How You Can Do This?

You can use Microsoft Excel workbook as records supply using report codecs in Data Services. Excel work ebook need to be available on Windows report machine or Unix File device.

Q7. How Many Types Of Data Stores Are Present In Data Services?

Three.

Database Datastores: provide a simple manner to import metadata without delay from an RDBMS.

Application Datastores: allow users without difficulty import metadata from maximum Enterprise Resource Planning (ERP) systems.

Adapter Datastores: can provide get entry to to an software’s statistics and metadata or simply metadata.

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

Delimited

SAP Transport

Unstructured Text

Unstructured Binary

Fixed Width

Q9. What Are Memory Datastores?

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

Q10. What Are The Steps Included In Data Integration Process?

Stage records in an operational datastore, facts warehouse, or facts mart.

Update staged facts in batch or actual-time modes.

Create a single environment for developing, trying out, and deploying the complete information integration platform.

Manage a single metadata repository to seize the relationships among specific extraction and get entry to methods and  provide included lineage and effect analysis.

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

Yes

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

DS Management Console → Job Execution History

Q13. Define Data Services Components?

Data Services consists of the subsequent fashionable components:

Designer

Repository

Job Server

Engines

Access Server

Adapters

Real-time Services

Address Server

Cleansing Packages, Dictionaries, and Directories

Management Console

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

Reusable Objects:

Most of the objects which can be saved in repository can be reused. When a reusable objects is described and shop in the nearby repository, you could reuse the item with the aid of developing calls to the definition. Each reusable item has only one definition and all of the calls to that object seek advice from that definition. Now if definition of an object is modified at one region you are changing item definition at all of the locations in which that item appears.

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

Single Use Objects:

All the gadgets which are described in particular to a activity or information glide, they may be referred to as single use objects. Example-specific transformation utilized in any facts load.

Q15. What Is Slowly Changing Dimension?

SCDs are dimensions which have information that modifications over time.

Q16. Is File Format In Data Services Type Of A Data Store?

No, File layout is not a datastore type.

Q17. List The Data Integrator Transforms?

Data_Transfer

Date_Generation

Effective_Date

Hierarchy_Flattening

History_Preserving

Key_Generation

Map_CDC_Operation

Pivot Reverse Pivot

Table_Comparison

XML_Pipeline

Q18. What Are Name Match Standards And How Are They Used?

Name match standards illustrate the more than one approaches a name can be represented.They are used in the fit process to significantly growth in shape effects.

Q19. What Is The Use Of Array Fetch Size?

Array fetch length shows the wide variety of rows retrieved in a unmarried request to a supply database. The default fee is a hundred@Higher numbers reduce requests, reducing network traffic, and probable improve overall performance. The maximum price is 5000.

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

SCD Type 1 No records upkeep

Natural consequence of normalization

SCD Type 2 Preserving all records and new rows

There are new rows generated for significant modifications

You need to use of a completely unique key

There are new fields are generated to store records statistics

You need to control an Effective_Date subject.

SCD Type 3 Limited history protection

In this most effective two states of statistics are preserved - current and vintage

Q21. Define The Terms Job, Workflow, And Dataflow?

A task is the smallest unit of labor that you can schedule independently for execution.

A work waft defines the decision-making procedure for executing statistics flows.

Data flows extract, transform, and cargo information. Everything having to do with information, along with reading sources, reworking records, and loading targets, happens internal a data flow.

Q22. What Is Linked Data Store? Explain With An Example?

There are various database companies which most effective offers one way communication path from one database to any other database. These paths are called database links. In SQL Server, Linked server permits one manner communique path from one database to other.

Example:

Consider a neighborhood database Server name “Product” shops database hyperlink to get admission to information on faraway database server called Customer. Now customers which are connected to remote database server Customer can’t use the identical hyperlink to get entry to records in database server Product. User which might be related to “Customer” must have a separate link in statistics dictionary of the server to access the facts in Product database server.

This communication course among  databases are known as database hyperlink and Datastores that are created among these linked database relationships is referred to as connected Datastores.

There is a possibility to attach Datastore to some other Datastore and importing an external database link as alternative of Datastore.

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

It is a developer device which is used to create objects encompass information mapping, transformation, and logic. It is GUI primarily based and paintings as dressmaker for Data Services.

You can create diverse items using Data Services Designer like Project, Jobs, Work Flow, Data Flow, mapping, modifications, etc.

Q24. Which Is Not A Data Store Type?

File Format

Q25. What Is The Template Table?

In Data Services, you can create a template table to transport to goal machine that has equal structure and records type as source desk.

Q26. What Are The Different Types Of Embedded Data Flow?

One Input: Embedded information go with the flow is delivered on the cease of dataflow.

One Output: Embedded records glide is introduced at the start of a facts drift.

No enter or output: Replicate an current facts waft.

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

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

Q28. What Is A Real Time Job?

Real-time jobs “extract” statistics from the body of the actual time message acquired and from any secondary sources used in the process.

Q29. Why Do We Need A Staging Area In An Etl Process?

There is a staging area this is required for the duration of ETL load.

There are various motives why a staging location is required:

As supply structures are simplest available for specific time frame to extract records and this time is much less than general information load time so Staging vicinity permits you to extract the information from supply gadget and hold it in staging vicinity before time slot is ended.

Staging region is needed when you need to get information from multiple facts sources together. If you need to join  or greater structures collectively. Example- You will no longer be able to carry out a SQL query becoming a member of two tables from two physically one of a kind databases.

Data extractions time slot for different systems range as per the time quarter and operational hours.

Data extracted from source structures may be used in more than one information warehouse machine, Operation Data stores, and so on.

During ETL you could carry out complicated differences that allows you to perform complex alterations and require more area to store the records.

Q30. What Is Sap Data Services?

SAP BO Data Services is an ETL device used for Data integration, statistics first-class, facts profiling and data processing and permits you to integrate, remodel depended on facts to data warehouse gadget for analytical reporting.

BO Data Services consists of a UI development interface, metadata repository, facts connectivity to supply and target device and control console for scheduling of jobs.

Q31. What Is The Use Of Conditionals?

You can also upload Conditionals to workflow. This permits you to implement If/Else/Then good judgment on the workflows.

Q32. What Is The Use Of Query Transformation?

This is most commonplace transformation utilized in Data Services and you may perform beneath capabilities:

Data filtering from resources

Joining statistics from more than one assets

Perform functions and variations on data

Column mapping from input to output schemas

Assigning Primary keys

Add new columns, schemas and features resulted to output schemas

As Query transformation is most generally used transformation, so a shortcut is supplied for this query in tool palette.

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

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

Below points need to be taken into consideration whilst migrating a relevant repository to improve version:

Point 1

Take the backup of vital repository all tables and objects.

Point 2

To hold version of items in statistics offerings, keep a valuable repository for every version. Create a new important history with new version of Data Services software program and replica all objects to this repository.

Point 3

It is always advocated in case you set up new version of Data Services, you should improve your significant repository to new edition of items.

Point four

Also upgrade your neighborhood repository to same model as exceptional version of vital and local repository may not work at the identical time.

Point 5

Before migrating the crucial repository, test in all of the gadgets. As you don’t improve vital and neighborhood repository simultaneously, so there is a want to check in all the items. As once you have got your vital repository upgraded to new edition, you may now not be able to check in gadgets from neighborhood repository which is having older version of Data Services.

Q34. What Is The Use Of Case Transform?

Use the Case remodel to simplify department good judgment in information flows by consolidating case or choice-making common sense into one remodel. The remodel permits you to split a records set into smaller units based on logical branches.

Q35. What Is Substitution Parameter?

The Value this is regular in one environment, however can also change while a job is migrated to any other environment.

Q36. List The Data Quality Transforms?

Global_Address_Cleanse

Data_Cleanse

Match

Associate

Country_id

USA_Regulatory_Address_Cleanse

Q37. What Is An Embedded Dataflow?

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

Q38. How Do You Improve The Performance Of Data Flows Using Memory Datastore?

You can create Datastore the usage of memory as database type. Memory Datastore are used to improve the performance of facts flows in real time jobs as it shops the statistics in memory to facilitate short get entry to and doesn’t require to visit original records supply.

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

The reminiscence tables stay alive until activity executes and facts in memory tables can’t be shared between distinctive real time jobs.

Q39. 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?

The Merge transform.

Q40. What Is A Transformation In Data Services?

Transforms are used to govern data units as inputs and creating one or more than one outputs. There are various transforms that may be used in Data Services.

Q41. What Are Reusable Objects In Dataservices?

Job, Workflow, Dataflow.

Q42. What Is A Script?

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

Q43. What Is A Repository In Bods? What Are The Different Types Of Repositories In Bods?

Repository is used to store meta-facts of gadgets used in BO Data Services. Each Repository have to be registered in Central Management Console CMC and is related with single or many job servers that is responsible to execute jobs that are created via you.

There are 3 forms of Repositories:

Local Repository:

It is used to keep the metadata of all objects created in Data Services Designer like mission, jobs, information waft, work glide, etc.

Central Repository:

It is used to govern the model control of the items and is used for multiuse improvement. Central Repository stores all the versions of an application object so it lets in you to transport to previous variations.

Profiler Repository:

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

Q44. What Are File Formats?

A record layout is a hard and fast of houses describing the structure of a flat document (ASCII). File formats describe the metadata structure.

File layout gadgets can describe files in:

Delimited format: Characters such as commas or tabs separate every area.

Fixed width layout: The column width is specific by the consumer.

SAP ERP and R/3 format.

Q45. What Is An Embedded Data Flow?

Embedded facts float is known as facts flows which can be referred to as from some other records drift inside the design. The embedded information go with the flow can include more than one quantity of supply and targets however simplest one enter or output pass information to main statistics drift.

Q46. What Is The Difference Between Dictionary And Directory?

Directories offer statistics on addresses from postal authorities. Dictionary files are used to pick out, parse, and standardize data inclusive of names, titles, and firm data.

Q47. What Is Repository? List The Types Of Repositories?

The DataServices repository is a fixed of tables that holds consumer-created and predefined device gadgets, source and target metadata, and transformation rules.

There are 3 types of repositories.

A nearby repository

A valuable repository

A profiler repository

Q48. What Is The Use Of Businessobjects Data Services?

BusinessObjects Data Services offers a graphical interface that allows you to effortlessly create jobs that extract facts from heterogeneous assets, remodel that records to satisfy the commercial enterprise requirements of your enterprise, and load the records right into a unmarried vicinity.

Q49. 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?

Data Cleanse: Parse names into given and own family.

Address Cleanse: Validate deal with facts.

Match: Find duplicates.

Q50. What Does A Lookup Function Do? How Do The Different Variations Of The Lookup Function Differ?

All research capabilities go back one row for every row within the source. They vary in how they choose which of several matching rows to go back.