Astera Data Stack
search
⌘Ctrlk
Astera Data Stack
  • Welcome to Astera Data Stack Documentation
    • Upgrading Astera 6 to Version 7
    • Release Notes for Astera 7.1
    • What is New in Astera 7.4
    • What’s New in Astera 7.4.1.221
    • What’s New in Astera 7.6
    • Upgrading to Astera 7.6
    • System Requirements
    • Installing Astera Data Integrator
    • Setting up Astera Integration Server 7
    • UI Walkthrough - Astera Data Integrator
    • Introducing Dataflows
    • Sources
    • Transformations
      • Aggregate Transformation
      • Apply To All Transformation
      • Constant Value Transformation
      • Data Cleanse Transformation
      • Data Quality Rules Transformation
      • Denormalize Transformation
      • Distinct Transformation
      • Expression Transformation
      • Filter Transformation
      • Function Transformations
      • Join Transformation
      • Merge Transformation
      • Normalize Transformation
      • Passthru Transformation
      • Rest Client
      • Route Transformation
      • Sequence Generator Transformation
      • Sort Transformation
      • Sources as Transformations
      • Subflow Transformation
      • Tree Join Transformation
      • Union Transformation
      • Web Service Transformation
    • Destinations
    • Data Logging and Profiling
    • Database Write Strategies
    • Text Processors
    • Adding Workflow Tasks
    • Creating Workflows
    • Using Workflow Designer
    • Customizing Workflows With Parameters
    • Workflows with a Dynamic Destination Path
    • Resuming and Rerunning Workflows in Astera
    • Using Subflows
    • Functions Glossary
    • Introducing Function Transformations
    • Custom Functions
    • Logical
    • Conversion
    • Math
    • Financial
    • String
    • Date Time
    • Files
    • Date Time With Offset
    • GUID
    • Encoding
    • Regular Expressions
    • TimeSpan
    • Matching
    • User Guide
    • Report Model Interface
    • Use Cases
    • Exporting Options
    • Miscellaneous
    • Project Management
    • Job Scheduler
    • Configuring Google Drive API through REST Client in Astera
    • Connecting to Eloqua using Astera REST API
    • POSTing Data Using the REST Client
    • Using the REST Client to Download a Text File
    • Lineage and Impact Analysis
    • Setting Up Oracle ODP.Net Connectivity in Astera
    • Running Microsoft Access Database Engine with Astera
    • Oracle Client Tools Setup
    • Oracle Data Load Options
    • Job Trace Improvements
    • SmartMatch Feature
    • Synonym Dictionary File
    • Using the Data Source Browser in Astera
    • Astera Best Practices - Dataflows
    • Cardinality Errors FAQs
    • Overview of Cardinality in Data Modeling
gitbookPowered by GitBookgitbook
  1. Dataflows

Transformations

Aggregate Transformationchevron-rightApply To All Transformationchevron-rightConstant Value Transformationchevron-rightData Cleanse Transformationchevron-rightData Quality Rules Transformationchevron-rightDenormalize Transformationchevron-rightDistinct Transformationchevron-rightExpression Transformationchevron-rightFilter Transformationchevron-rightFunction Transformationschevron-rightJoin Transformationchevron-rightMerge Transformationchevron-rightNormalize Transformationchevron-rightPassthru Transformationchevron-rightRest Clientchevron-rightRoute Transformationchevron-rightSequence Generator Transformationchevron-rightSort Transformationchevron-rightSources as Transformationschevron-rightSubflow Transformationchevron-rightTree Join Transformationchevron-rightUnion Transformationchevron-rightWeb Service Transformationchevron-right
PreviousXML/JSON File Sourcechevron-leftNextAggregate Transformationchevron-right

© Copyright 2026, Astera Software