Question: 1
How to Use a WHERE clause to select only customers in North America
(North American countries are United States, Canada, and Mexico which have
COUNTRYID values of 1, 2,and 11)?
Question: 2
How to Add the Query transform to the workspace between the source and target?
A To open the Query Editor , in the data flow workspace, double click the Query transform.
B To add a new Query template to the data flow, in the tool palette, choose the Query Transform icon, and click the workspace.
C 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.
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.
Answer : B, C, D
Show Answer
Hide Answer
Question: 3
How to Create a new template table alpha_NA_customer
in the Delta datastore as the target object?
Question: 4
In the workspace for Alpha_NACustomer_DF , How to add the customer table from the Alpha datastore as the source object?
Question: 5
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 Project area, right click the project name.
B Choose New Batch Job.
C 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.
D In the tool palette, choose the Data Flow icon & Click the workspace where you want to add the data flow.
E 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.
F In the Local Object Library , select the Datastores tab
G To save changes, choose OK
Answer : A, B, C, D
Show Answer
Hide Answer