SAP Data Services

What's Data Services Repositories. Repository is the space in a database server which stores the metadata of the objects used in SAP Data Services. It's a Data services function.

Which repositories are used with SAP BODS. Local Repository - is used to store the metadata of the objects designed in the DS designer by the developer. NOTE: to logon to the SAP DS Designer, we require a local repository and its credentials. Central Repository - is used to share objects between multiple local repositories. Profiler Repository - is used to store metadata of profiling task performed in DS Designer. Middle Repository.

Jobs in Data services. Batch Job - Process bulk namount of of data (offline data). (Traiter une grande quantité de données) NOTE : Executed by the developer. Real Time Job - Process online data. (Online data) NOTE : Executed as a real time service by the real time client. Full Time Job.

Services in BODS. Job Server - Retrieves the job information and starts the data engine to process. Data Engine - Processes to perform data extraction, transformation, and movement. Access Server - A real-time, request-reply message broker. Software server.

What's Data services designer. Developer or designer tool. It's an easy-to-use GUI. Devellopers can design, modify and test the objects that consist of data mappings, transformations, and control logic. Desktop tool and client tool. Python environment.

There's 2 types of Central Repositories in BODS. Secure Central Repository. Unsecured Central Repository. Cloud Central Repository.

What services are request to process a batch job?. Job server + Data Engine. Data Engine + profiler.

What services are request to process a real-time job?. Access Server + Job Server + Data Engine. Profiler + Job Server.

What's Data Service Management Console. it's a web-based tool with collection of 6 web Application. It's a python environment.

Data Services Management Console is a web-based tool with collection of 6 web applications. choose. Administrator -> Administration tool. Impact and lineage analysis -> Reporting Tool. Operational dashboard -> Reporting Tool. Auto documentation -> Reporting Tool. Data validation -> Reporting Tool. Data quality reports -> Reporting Tool. Python database.

Data quality components. Directories -> Storage location at OS level. Dictionaries -> Storage location at database level. Adress server -> Services which helps to process to data quality address transformations.

What's Central Management Console. - Web-based tool coming with SAP BI/BO or SAP IPS (Information plaform services). - Involved in BODS architecture form 4x versions - Used to maintain security and user authentications. Pyton software.

What's information steward. - Data Management tool - Information steward and data services complement each other in overall data quality / data governance - Used to develop custom cleansing packages and perform match review. Python software.

ETL - Extract transform and load. Moving data from One source (Source) to another (Target). Delete data.

How Data service can help us and its core functionalities. Discover, cleanse, enhance and integrate data - and make it ready for business use. ensure consistency cross data source - wether the are on-premise, in the cloud or embedded in applications. Improve processes & maximize the value of your data - by enabling users to make confident decisions based on data they can trust.

Each time the job is executed, a log is created. Yes. No.

Job monitoring in data service has 3 tapes. Trace - Monitor - Error. Trace - Error - Pie. Monitor - Error - Table.

Logs can also be found in Sap Data Service Magement Console. Yes. No.

In Sap data Services, Job can be schedule un Sap data services Management Console. Yes. No.

Case Transform can help to split one table in multiple tables. Yes. No.

Choose the right answer. The LEFT JOIN selects the common rows as well as all the remaining rows from the left table. The INNER JOIN selects only the common rows between two tables. The Outer joins are joins that return matched values and unmatched values from either or both tables.

Case Transform can be used to split one table in multiple tables. Yes. No.

In Merge Transform, all the Sources Tables must have the same structure. Yes. No.

Variables are used to increase the flexibility and reusability of components generated by your application by using local and global variables. Yes. No.

Globals variables are created at which level?. Job level. Report level.

locals variables are created at which level?. Object level. Report level.

Locals variables are created at the object level?. Yes. No.

Substitution parameters define parameters that have a constant value for one environment. But the value can be changed for used in other environment. Yes. No.

Substitution parameters is defined at the repository level. Yes. No.

When we create a variable, we can assign it a default value. Yes. No.

CAST function is used to change the data type. Yes. No.

Slow changing dimensions (SCD) choose the correct answer. SCD Type 1 - No history preservation. SCD Type 2 - unlimited history preservation. SCD Type 3 - limited history preservation.

CDC. Change Data Capture. Charles de Gaule.