Creating and importing into Decision Data Store Data Sets
5 タスク
30 分
シナリオ
In the Sample application, Sample-Data-Employees class is available for the exercise. The class contains the data structure for employee data.
Download the SampleEmployees data for the exercise, create a new Decision Data Store Data Set (DDS Data Set), and then complete the given tasks.
Use the following credentials to log in to the exercise system:
| Role | User name | Password |
|---|---|---|
| System architect | SystemArchitect | rules |
Your assignment consists of the following tasks:
Task 1: Download the CSV file to your local drive
The SampleEmployees.csv file is available on the system through a binary file Rule. Download the file to your local drive.
Task 2: Create a new DDS Data Set
Create a new DDS Data Set in the Sample-Data-Employees class named EmployeeData.
Add the EmployeeDepartment and EmployeeID fields as keys.
Task 3: Import the data into the Decision Data Store Data Set
Use the downloaded ZIP file to import the records into the DDS Data Set.
Task 4: Preview the data for a specific key
Browse and review the data for the EmployeeDepartment Garden & Industrial.
Task 5: Preview the data for multiple keys
Add EmployeeID to the Data Set query, and preview the data for EmployeeDepartment Garden & Industrial and EmployeeID Employee209.
チャレンジ ウォークスルー
詳細なタスク
1 Download the CSV file to your local drive
- Log in as the System Architect:
- In the User name field, enter SystemArchitect.
- In the Password field, enter rules.
- In the header of Dev Studio, in the search field, enter SampleEmployees, and then click enter.
- In the list of results, click Employees SampleEmployees ZIP.
- On the Rule form, click Download file to download the file to your local drive.
2 Create a new DDS Data Set
- In the navigation pane of Dev Studio, click App to open the Application Explorer.
- In the Application Explorer, search for the Sample-Data-Employees class.
- In the Application Explorer, right-click the Sample-Data-Employees class, then select Create > Data Model > Data Set.
- On the Create Data Set tab, create a new Data Set:
- In the Label field, enter Employees.
- In the Type list, select Decision Data Store.
- In the upper-right corner, click Create and open.
- In the Keys section, complete the following details:
- In the empty Field list, enter or select .EmployeeDepartment.
- Click Add key.
- In the empty Field list, enter or select .EmployeeID.
補足: Once the keys are assigned, they cannot be changed. You must create a new DDS Data Set to add new keys or remove existing keys.
- In the upper-right corner, click Save.
- In the Keys section, click Show details link to determine which Cassandra table the system creates for the DDS Data Set.
3 Import the data in the Decision Data Store Data Set
- On the Data set: Employees tab, in the upper-right corner, click Actions > Import to import the data.
- In the Import Data Set dialog, click Choose File, then select the file you downloaded in Task 3.
- Click Import.
- Click Done.
- In the Import Data Set dialog, click Choose File, then select the file you downloaded in Task 3.
4 Preview the data for a specific key
- On the Data set: Employees tab, in the upper-right corner, click Actions > Run.
- In the Run Data Set: Employees window, complete the following details:
- In the run context, in the Operation list, select Browse by keys.
- In the Key list, select EmployeeDepartment.
- In the Value field, enter Garden & Industrial.
- In the upper-right corner of the run context, click Run to view the run results. Note that the query returns five results.
- Close the Data Set Preview window.
5 Preview the data for multiple keys
- On the Run Data Set: Employees window, click the Add key to add a new key:
- In the empty Key list, select EmployeeID.
- In the Value field, enter Employee209.
- In the upper-right corner of the run context, click Run to view the run results.
Note that the results return the results for the combination of the EmployeeDepartment and EmployeeID keys.