Data Cleansing and Transformation Features and Functions
|
- Creates user-definable business rules and definitions to automatically monitor data standards
- Conditional and mathematic data transformations
- Query parsing
- Visible data output at each stage of transformation
- Incremental aggregation and computation of aggregates by the tool in one pass of the source data
- Specifies complex transformations using only built-in transformation objects
- User-defined SQL statements execution
- Data landing on disc not required
- Creates data warehouse with any database
- Performs procedural data cleansing functions
|
|
ETL Features and Functions
|