Database Reference
In-Depth Information
Activity
Activity
Canceled
Compensated
Send
Message
Correct
Error
Canceled and compensated activities
Input Data
Input Data
Input Data
Insert Data
File:
BadCities.txt
Type:
Text
Options:
Headers, Empty
File:
Time.xls
Type:
Excel
Database:
Northwind
Table:
Customers
Database:
Northwind
Query:
< SQL Query >
Insert Data
Update Data
Delete Data
Add Column
Column:
SalesAmount =
D.UnitPrice * (1-Discount) *
Quantity
Database:
NorthwindDW
Table:
Time
Mappings:
TimeKey->OrderDateKey
Options:
Append
Database:
NorthwindDW
Table:
Product
Columns:
To=Now()
Where:
ProductKey
Matches:
ProductKey
Database:
NorthwindDW
Table:
Product
Where:
ProductKey
Matches:
ProductKey
Update
Column
Update
Column
Add Column
Drop Column
Column
:Freight
Database:
NorthwindDW
Query:
< SQL Query >
Column:
Freight
Database:
NortwhindDW
Query:
<SQL query>
Column:
Description =
Trim(Description)
Column:
Picture
Rename
Column
Convert
Column
Remove
Duplicates
Agreggate
Columns:
Date: Date
DayNbWeek: Smallint
Group By:
OrderNo
Columns:
Cnt=Count(*),
TotalSales=Sum(SalesAmount)
Column:
Region->State
Multicast
Sort
Input:
EmployeeKey, CityKey
Output*:
EmployeeKey,
CityKey
Columns:
OrderDate, Amount DESC
Unary data tasks
Search WWH ::
Custom Search