A simple condition includes one or more conditions that compare the specified master and detail sources. A simple condition must use the following format:

For a sorted Joiner transformation, the condition must use the equality operator.

For an unsorted Joiner transformation, the condition can use any of the following operators: =, !=, >, >=, <, <=.

For example, if two sources with tables called EMPLOYEE_AGE and EMPLOYEE_POSITION both contain employee ID numbers, the following condition matches rows with employees listed in both sources:

The Developer tool validates datatypes in a simple condition. Both ports in the condition must have the same datatype. If you need to use two ports in the condition with non-matching datatypes, convert the datatypes so they match.

You can configure a list of join conditions in a simple condition. When you configure multiple join conditions, all the conditions must be true to make the join.

For example, you might configure the following statements in a simple condition:

StoreID = StoreNO
Dept    = Department
Salary  > Commission

If you view the same statements as an Advanced Condition, the join condition appears as the following expression:

StoreID = StoreNO AND Dept = Department AND (Salary > Commission)