Apply Table Filters
On this page
You can use table filters to migrate specific subsets of your table data. Table filters allow you to apply SQL where and row limit clauses when pulling data from your table.
Before you Begin
Table filters are applied while you are creating mapping rules. See Create Rules From Relational for more details.
You can apply one filter per table. Each filter can have a SQL where clause, a row limit clause, or both.
Steps
Apply a table filter
From the Schema model pane, click the table that you want to apply a filter to.
On the Filter on section in the edit mapping rule pane, click + Add.
Under the SQL query header, enter a SQL where criteria. The SQL you specify must be ANSI SQL compliant with your relational database.The following are examples of SQL where clauses used to apply SQL query table filters:
LASTNAME LIKE '%SMITH%'LASTNAME = 'SMITH'LASTNAME IN('SMITH')LASTNAME IN(SELECT LASTNAME FROM ASIA_CUSTOMERS WHERE ID < 100000)
(Optional) Add a row limit
Under the Row limit header, click the Limit number of rows radio button and enter a value. This applies a limit clause at the end of your SQL query.
Save your table filter
Click Save and close.
Note
After you save your filter, the Schema model pane displays a icon for any tables containing a filter under the Relational header.