Rate Table You can use columns in the Rate Table dimension to add information about the Rate Table used to calculate commission data. Screen Rate Table Columns Columns The following […]
Table
Using the Pivot Table View
Using the Pivot Table View The pivot table view displays results in a pivot table, which provides a summary view of data in cross-tab format and enables users to see […]
Using the Table View
Using the Table View You can use the table view to show results in a standard table. Users can navigate and drill down in the results. You can add report […]
SHOW TABLE
SHOW TABLE Summary The SHOW TABLE command returns a result set containing metadata describing the specified table. The metadata includes the table’s schema, columns, and column data types, amon...
DROP TABLE
DROP TABLE Summary The DROP TABLE command drops the specified table from the environment. Dropping a table deletes all existing data in the table (the data is not recoverable). Syntax […]
Query Salesforce with SFDC()
Salesforce Connector Query Salesforce with SFDC() Use the SFDC() table function to issue SELECT queries against Salesforce.com objects. Connect’s SFDC() table function returns result sets that you c...
Use Steps and Pipelines
Data Processing with Steps and Pipelines Your primary tool for creating ETL mappings and automating your Incent processes is using step and pipeline domain objects. You can bundle a series of [&helli...
SFDC() Simple Select
Our first example is a query of our Opportunity table in SFDC. NOTE: Enter your own valid SFDC info (for the Salesforce.com TableName, UserName, and Password) to query your SFDC […]
INSERT
INSERT with a Value List Use INSERT statements with literal values to add new rows to a table. For example: 1 SQL> insert into staging.order_item(batch_name, order_code, item_code, incentive...