Yellowbrick Data Warehouse Connector > Mappings and mapping tasks with Yellowbrick Data Warehouse > Yellowbrick Data Warehouse sources in mappings
  

Yellowbrick Data Warehouse sources in mappings

In a mapping, you can configure a Source transformation to represent a Yellowbrick Data Warehouse source.
The following table describes the source properties that you can configure in a Source transformation:
Property
Description
Connection
Name of the source connection, or create a connection parameter.
Source type
Type of the source object. Select Single Object, Multiple Objects, or Parameter.
To define a parameter, select Parameter as the source type, and then specify the parameter in the Parameter property.
Object
Name of the source object.
The following table describes the Yellowbrick Data Warehouse query options that you can configure in a Source transformation:
Property
Description
Filter
Filter value in a read operation. Click Configure to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source.
You can specify the following filter conditions:
  • - Not parameterized. Use a basic filter to specify the object, field, operator, and value to select specific records.
  • - Completely parameterized. Use a parameter to represent the field mapping.
  • - Advanced. Use an advanced filter to define a more complex filter condition.
Sort
Add conditions to sort records.
You can specify the following sort conditions:
  • - Not parameterized. Select the fields and type of sorting to use.
  • - Parameterized. Use a parameter to specify the sort option.
  • - Sort Order. Sorts data in ascending or descending order, according to a specified sort condition.
The following table describes the Yellowbrick Data Warehouse advanced source properties that you can configure in a Source transformation:
Property
Description
Pre-SQL
The pre-SQL commands to run a query before you read data from Yellowbrick Data Warehouse.
Post-SQL
The post-SQL commands to run a query after you write data to a target.
SchemaPolicy
Policy for naming the schemas for tables.
Select one of the following options:
  • - None
  • - Specified
  • - FromImport
  • - FromConnection
SchemaName
Name of the schema. Required if you select the Specified option for SchemaPolicy.
Filter Condition
Not applicable
IsNative
Not applicable
TableName
The table to read from. If not specified, use the table name in the source definition. You must add the Table name without quotes.
Tracing Level
Not applicable