Astera Data Stack
search
Ctrlk
  • Welcome to Astera Data Stack Documentation
  • Release Notes
    • Astera 8.0 - What's New, What's Fixed, and What's Improved
    • Astera 8.0 - Known Issues
    • Astera 8.1 - Release Notes
    • Astera 8.2 Release Notes
    • Astera 8.3 Release Notes
    • Astera 8.4 Release Notes
    • Astera 8.5 Release Notes
  • Getting Started
    • Astera 8 - Important Considerations
    • Astera 8 - System Requirements
    • Configuring the Server
    • Connecting to a Different Astera Server from the Lean Client
    • Connecting to an Astera Server using Lean Client
    • How to Build a Cluster Database and Create a Repository
    • How to Login from Lean Client
    • Setting up a Server Certificate (.pfx) File in a New Environment
    • Installing Client and Server Applications
    • Licensing Model in Astera 8
    • Migrating from Astera 7.x to Astera 8
    • UI Walkthrough - Astera 8.0
    • User Roles and Access Control
  • Dataflows
    • Sourceschevron-right
    • Transformationschevron-right
      • Introducing Transformations
      • Aggregate Transformation
      • Constant Value Transformation
      • Data Cleanse Transformation
      • Denormalize Transformation
      • Distinct Transformation
      • Database Lookup Transformation
      • Expression Transformation
      • File Lookup Transformation
      • Filter Transformation
      • Join Transformation
      • List Lookup Transformation
      • Merge Transformation
      • Normalize Transformation
      • Passthru Transformation
      • Reconcile Transformation
      • Route Transformation
      • Sequence Generator Transformation
      • Sort Transformation
      • Sources as Transformations
      • Subflow Transformation
      • SQL Statement Lookup Transformation
      • Switch Transformation
      • Tree Join Transformation
      • Tree Transform
      • Union Transformation
    • Destinationschevron-right
    • Data Logging and Profilingchevron-right
    • Database Write Strategieschevron-right
    • Text Processorschevron-right
    • Data Warehousechevron-right
  • WORKFLOWS
    • What Are Workflows?
    • Using the Workflow Designer
    • Creating Workflows in Astera
    • Decision Task
    • EDI Acknowledgement Task
    • File System Task
    • File Transfer Task
    • OR Task
    • Run Dataflow Task
    • Run Program Task
    • Run SQL File Task
    • Run SQL Script Task
    • Run Workflow Task
    • Send Mail Task
    • Workflows with a Dynamic Destination Path
    • Customizing Workflows with Parameters
    • GPG-Integrated File Decryption in Astera
  • Subflows
    • Using Subflows in Astera
  • Functions
    • Introducing Function Transformations
    • Custom Functions
    • Logicalchevron-right
    • Conversionchevron-right
    • Mathchevron-right
    • Financialchevron-right
    • Stringchevron-right
    • Date Timechevron-right
    • Fileschevron-right
    • Date Time With Offsetchevron-right
    • GUIDchevron-right
    • Encodingchevron-right
    • Regular Expressionschevron-right
    • TimeSpanchevron-right
    • Matchingchevron-right
  • Report Model
    • User Guidechevron-right
    • Report Model Interfacechevron-right
    • Use Caseschevron-right
    • Exporting Optionschevron-right
    • Miscellaneouschevron-right
  • API Flows
    • API Consumptionchevron-right
  • Project Management
    • Project Managementchevron-right
    • Job Schedulingchevron-right
  • Use Cases
    • End-to-End Use Caseschevron-right
  • Connectors
    • Connecting to Amazon Aurora Database
    • Connecting to Amazon RDS Databases
    • Connecting to Amazon Redshift Database
    • Connecting to Cloud Storage
    • Connecting to Google Cloud SQL in Astera
    • Connecting to MariaDB Database
    • Connecting to Microsoft Azure Databases
    • Connecting to MySQL Database
    • Connecting to Netezza Database
    • Connecting to Oracle Database
    • Connecting to PostgreSQL in Astera
    • Connecting to Salesforce Database
    • Connecting to Salesforce - Legacy Database
    • Connecting to SAP HANA Database
    • Connecting to Snowflake Database
    • Connecting to Vertica Database
    • Setting Up IBM DB2 iSeries Connectivity in Astera
  • Miscellaneous
    • Cloud Deploymentchevron-right
    • Context Information
    • Pushdown Mode
    • Role Based Access Control in Astera
    • Safe Mode
    • Server Command Line Utility
    • SmartMatch Feature
    • Synonym Dictionary File
    • Updating Your License in Astera
    • Using Dynamic Layout/Template Mapping in Astera
    • Using Output Variables in Astera
    • Using the Data Source Browser in Astera
  • Best Practices
    • Astera Best Practices - Dataflows
    • Overview of Cardinality in Data Modeling
    • Cardinality Errors FAQs
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. Dataflows

Transformations

Introducing Transformationschevron-rightAggregate Transformationchevron-rightConstant Value Transformationchevron-rightData Cleanse Transformationchevron-rightDenormalize Transformationchevron-rightDistinct Transformationchevron-rightDatabase Lookup Transformationchevron-rightExpression Transformationchevron-rightFile Lookup Transformationchevron-rightFilter Transformationchevron-rightJoin Transformationchevron-rightList Lookup Transformationchevron-rightMerge Transformationchevron-rightNormalize Transformationchevron-rightPassthru Transformationchevron-rightReconcile Transformationchevron-rightRoute Transformationchevron-rightSequence Generator Transformationchevron-rightSort Transformationchevron-rightSources as Transformationschevron-rightSubflow Transformationchevron-rightSQL Statement Lookup Transformationchevron-rightSwitch Transformationchevron-rightTree Join Transformationchevron-rightTree Transformchevron-rightUnion Transformationchevron-right
PreviousXML/JSON File Sourcechevron-leftNextIntroducing Transformationschevron-right

© Copyright 2025, Astera Software