Setting SQ Properties - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software
Use this procedure to change loader connection settings. A loader connection for Aster Database must already exist.
  1. Open the Informatica Workflow Manager.
  2. Connect to the repository.
  3. Navigate to the mapping that has Aster nCluster sources.
  4. Right-click and select Edit Application source qualifier.
  5. Click the SQ Properties tab.


  6. 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
  7. Click OK.
  8. Save the mapping.