Database Management

The purpose of these exercises is to become familiar with managing database tables via DataWORQ.

Exercises

1. Given a flat file (Iris.csv), create a new database table that contains the same data as the file. Copy the table above into a new table.

2. A flow file that you created is going to be used across various groups in your organization. Although the data transformation process is similar between groups, database and table names are not. Update your flow (\Samples\DBRename.flx) with parameters to make it easier to make these changes moving forward.

3. Given the flow file from above, output the maximum sepal length where the species is 'virginica'.

4. Given the flow file from above, simplify the number of nodes used where possible.

Hints

1. Read through Database Source, Database Export, and Flow Connections.

2. Read through Parameters.

3. Read through Database Source and Database Export.