In the Alpha Acquisitions database, the country for a customer is stored in a separate table and referenced with a code. To speed up access to information in the data warehouse, this lookup should be eliminated.
Use the lookup_ext function to exchange the ID for the country name in the customers table for Alpha with the actual value from the country table.
How to In the Alpha_NACustomer_DF workspace, delete an existing expression for the Country column in the Query transform.

• A.the Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query transform.
• B.In the Mapping tab for the Country field, delete the existing expression.
• C.In the Mapping tab, choose Functions.
• D.In the Select Function dialog box, choose Lookup Functions.
• E.In the Query Editor, in the output schema, choose the field Country.

Comment: *

Name: *

Email: *

Verification: *

In the Omega project, How to create a new batch jobAlpha_NACustomer_Job with a new data flow called Alpha_NACustomer_DF?

• A.In the tool palette, choose the Data Flow icon & Click the workspace where you want to add the data flow.
• B.Name the data flow Alpha_NACustomer_DF and, on your keyboard, press Enter. The job should open automatically. If it does not, open it by double-clicking.
• C.In the Local Object Library , select the Datastores tab
• D.Name the job Alpha_NACustomer_Job and, on your keyboard, press Enter. The job should open automatically. If it does not, open it by double-clicking.
• E.Choose New Batch Job.
• F.To save changes, choose OK
• G.In the Project area, right click the project name.

Comment: *

Name: *

Email: *

Verification: *

By which application you do Analyze the end-to-end impact and lineage for source and target objects used within the Data Services local repository?

• A.Impact and Lineage Analysis
• B.Data Quality Reports
• C.Data Validation Dashboard
• D.Administrator
• E.Operational Dashboard
• F.Auto Documentation

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 Query transform, create a new output column
TOTAL_VALUE , which will hold the new calculation.

• A.Choose the Where tab or the From tab.
• B.Choose Insert Below.
• C.To map the ORDERID column from the input schema to the same field in the output schema, select ORDERID and drag to the output schema
• D.In the output schema, right click ORDERID and choose New output column.

Comment: *

Name: *

Email: *

Verification: *

How to Add the Query transform to the workspace between the source and target?

• A.To connect the source table to the Query transform, select the source table, hold down the left mouse button, drag the cursor to the Query transform, and release the mouse button.
• B.To open the Query Editor , in the data flow workspace, double click the Query transform.
• C.To add a new Query template to the data flow, in the tool palette, choose the Query Transform icon, and click the workspace.
• D.To connect the Query transform to the target template table, select the Query transform, hold down the left mouse button, drag the cursor to the target table, and release the mouse button.

Comment: *

Name: *

Email: *

Verification: *