Collaborative work with task management (Exercise 11) Talend Enterprise Data Quality task management helps business users define analyses that will be configured by technical users and monitoring the work progress.

In this exercise, you will follow the data cleansing process which comprises three steps:
1) Task creation,
2) Task review,
3) Task completion.

Prerequisites:
To follow this tutorial, you need to extract and install the cif and crm databases zipped in the exampleFile.zip file available for download in the Download it! section of this tutorial.

Download it!

You want to practice?

Download exampleFile.zip to get the files used for this tutorial.

You can also download tutorialProject.zip containing all the jobs needed to carry out this tutorial.

You can also:
Send it!

Share it!

 


  
A task can be added to:

1) A database catalog or schema,
2) A database table,
3) An analysis,
4) A report.

Next
  
Create tasks


In the DQ Repository view:
Expand the Metadata, DB Connections, Staging_DB, crm and Tables nodes.
Right-click on the claim table.
Select Add task...

Next
In the Properties wizard:
Fill in the Description and the Priority.

Click Ok.

Next
In the DQ Repository view:
Expand the Data Profiling node.
Right-click on Analyses and select New Analysis.

Next
In the New Analysis wizard:
Select a Column analysis.
Click Next.
Do not configure that analysis.
Simply fill in the Name as claim_column_analysis, the purpose and the description.
Click Finish.

Next
Add a task onto it in order to ask your team to work on it. To do so:
Right-click on the analysis and select Add task...
Fill in the Description and Priority.
Click OK.

Next
Review tasks


To view the tasks, open the Window menu and select Show View...

Next
Expand the General folder and select the Tasks view.
Click OK.

Next
This will open the task panel in the right of your screen.
You can drag and drop this panel in order to place it next to the DQ Repository tab.

Next
You can see the two tasks you just created with their priority level, description, the resource (object) that the task refers to and the resource path in the project.

By double-clicking on a task, you will open the linked object: if you double-click on the analysis configuration to open it and start working on it.

Next
Complete a task


When your work is done on a particular task, you can mark it as "completed" whether by:

1) Checking the checkbox in the tasks list.

Next
2) Right-clicking on the task, selecting Properties and selecting the Completed checkbox.

Next
You can right-click on any task and select Delete Completed Tasks to remove the task from the list.


 

    Download it!     Send it!     Share it!

You want to practice?

Download exampleFile.zip to get the files used for this tutorial.

You can also download tutorialProject.zip containing all the jobs needed to carry out this tutorial.

Friends / colleagues may be interested in this tutorial? Send it to them!

You liked this tutorial ? Support it!

[ top ]