You can create a custom query at the mapping level. Use this feature to override those queries.
- Open the Informatica Workflow Manager.
- Connect to the repository.
- Locate the session, right-click and select Edit.
-
Click the Mapping tab.
- In the left pane, select the table name below Sources.
- Under Readers, select Aster nCluster Reader.
- Under Connections, set the Type as Relational.
- Under Connections, set the Value as the Aster nCluster Relational Connection you created.
- Under Properties, enter the session level properties. This query overrides the query on the SQ Properties tab.
- Click OK.
- Save the session.