C_DS_42 questions and answers

You are an ETL developer working on a data warehousing project. You need to load data from the product table and create a table for North American customers.

How to Create a new project called Omega?

You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column).

How do you calculate the average salaries for each department in the Query transform in SAP Data Services?

In the workspace for Alpha_NACustomer_DF ,

How to add the customer table from the Alpha datastore as the source object?

By which application you do View and export reports for batch and realtime jobs, such as job summaries and data quality transform reports?

The Marketing department would like to send special offers to customers who have placed a specified number of orders. This can be done by creating a custom function that must be called when a customer

order is placed. You want to create a custom function to accept the input parameters of the Customer ID, and the number of orders required to receive a special order, check the Orders table, and then create an initial list of eligible customers.
How to Create a new batch job and data flow, called Alpha_Marketing_Offer_Job and_Marketing_Offer_DF respectively, and a new global variable $G_Num_to_Qual.

By which application you do Manage your production environment including batch job execution, real-time services, web services, adapter instances, server groups, central repositories, profiler repositories, and more?

You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables. Use the sum function to calculate the total value of orders in the Order_Details table. How to create a new batch job called Alpha_Order_Sum_Job with a data flow Alpha_Order_Sum_DF .

Install the Management Console on a separate computer from other Data Services components.

Where does management Console runs?

How to Save and execute the Alpha_NACustomer_Job?

Execute the Alpha_NACustomer_Job in debug mode with a subset of records.
In the workspace for the Alpha_NACustomer_Job , add a filter between the source and the Query transform to filter the records, so that only customers from the USA are included in the debug session?

What do you call for that particular link of Clicking to return to the Management Console home page where you can select another application, for example?

Contains the repository name associated with the ________ Server?