Use this procedure to change loader connection settings. A loader connection for Aster Database must already exist.
- Open the Informatica Workflow Manager.
- Connect to the repository.
- Navigate to the mapping that has Aster nCluster sources.
- Right-click and select Edit Application source qualifier.
-
Click the SQ Properties tab.
-
Using mapping logic, enter the conditions.
- User Defined Join - write a join condition
- No. Of Sorted Ports - select the number of sorted ports
- Select Distinct - select distinct values
- Source Filter - write a join condition
- Click OK.
- Save the mapping.