When you configure a mapping, you can specify an SQL statement to override the default query used to read data from the Teradata source.
Specify the SQL override query in the source properties of the mapping. In the SQL override query, you can specify the columns that you want to use from the source database.
For example, use the following SQL override query to extract employee records, matching rows by employee location, from the Teradata source:
select EMPID, EMPNAME, AGE, DOB, DEPTID, LOCATION, DESIGNATION, SALARY from employee where CITY='San Jose'
When you run the mapping, the Secure Agent extracts specific employee records belonging to San Jose based on the where clause defined in the SQL override query.
You must ensure that the number of columns, order of columns, and the data type you specify in the query matches with the Teradata source object.
ASK INFAPreview
