Before you begin
You have already created a database analysis in the Profiling perspective of Talend Studio.
Click the [+] button at the bottom of the
Contexts view to add lines in the table.
Suppose that you want to profile a postal_code column and you want to analyze the postal codes that start with 15 in the development environment and with 75 in the production environment. And that you want to allow different concurrent connections per analysis in the two environments.
Click in the Name field and enter the name of the
variable you are creating.
Name the first variable where_clause for this example.
Repeat the above steps to define all the variables for the different
In this example, set the value of the where_clause variable in the Test context to
postal_code like '15%', and for the Prod context to
postal_code like '75%'. And set the value for the concurrent connections per analysis in the development and production environments to three and five respectively.
- Click at the bottom of the view to import any of the contexts created and centralized in the studio repository and use it with the current analysis.