Where is an SAP Data Services job executed?

• A.Designer application
• B.Management console
• C.Access server
• D.Job server

Comment: *

Name: *

Email: *

Verification: *

What are task's of data Services uses the SAP RFC Server Interface?

• A.Reading from SAP Open Hub destinations
• B.Loading SAP NetWeaver BW
• C.None of above
• D.Viewing Data Services logs from SAP NetWeaver BW
• E.Scheduling SAP jobs

Comment: *

Name: *

Email: *

Verification: *

In addition to the main databases for source information, records for orders are stored in flat files. You need to extract data from these flat files, and so must create the appropriate file format for the extraction. Adjust the data types for the columns proposed by the Designer based on their content. (Validate the correct statement).

• A.Enter Orders_Format as the format name.
• B.In the Column Attributes pane, change the field datatypes to the datatypes in the Column Attributes Values table.
• C.Right click the Flat Files node and choose New.
• D.In the ORDERDATE field, to change the format of the date, enter dd-mon-yyyy .
• E.In the Local Objects Library, choose Formats tab.
• F.Choose Save and close .

Comment: *

Name: *

Email: *

Verification: *

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 In the transform editor for the Query transform, propose a join between the two source tables.

• A.the Propose Join button.
• B.To open the Query Editor double click the Query .
• C.To connect the Query Transform, select the Query Transform , hold down the mouse button, drag it to the order_sum table, and release the mouse button.
• D.Choose the Where tab or the From tab.

Comment: *

Name: *

Email: *

Verification: *

How to Save and execute the Alpha_NACustomer_Job?

• A.In the Query editor, choose the WHERE tab
• B.To return to the Job workspace, in the tool bar, choose the Back icon & To return to the Data Flow workplace, double click the Data Flow.
• C.In the main menu, choose Project Save All & To save all changes, choose OK
• D.In the Project Area , right click the Alpha_NACustomer_Job and choose Execute & To accept the default execution properties, choose OK

Comment: *

Name: *

Email: *

Verification: *