Astera Data Stack
Ctrlk
  • Welcome to Astera Data Stack Documentation
  • Release Notes
    • 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
  • Setting Up
    • System Requirements
    • Installing Astera Data Integrator
    • Setting up Astera Integration Server 7
    • UI Walkthrough - Astera Data Integrator
  • Dataflows
    • 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
  • Workflows
    • Adding Workflow Tasks
    • Creating Workflows
    • Using Workflow Designer
    • Customizing Workflows With Parameters
    • Workflows with a Dynamic Destination Path
    • Resuming and Rerunning Workflows in Astera
  • Subflows
    • Using Subflows
  • Functions
    • 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
  • Report Model
    • User Guide
    • Report Model Interface
    • Use Cases
    • Exporting Options
    • Miscellaneous
  • Project Management
    • Project Management
    • Job Scheduler
  • Web Services
    • 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
  • Metadata Management
    • Lineage and Impact Analysis
  • Connectors and Providers
    • Setting Up Oracle ODP.Net Connectivity in Astera
    • Running Microsoft Access Database Engine with Astera
    • Oracle Client Tools Setup
    • Oracle Data Load Options
  • Miscellaneous
    • Job Trace Improvements
    • SmartMatch Feature
    • Synonym Dictionary File
    • Using the Data Source Browser in Astera
  • Best Practices
    • Astera Best Practices - Dataflows
    • Cardinality Errors FAQs
    • Overview of Cardinality in Data Modeling
Powered by GitBook
On this page
  1. Dataflows

Transformations

Aggregate TransformationApply To All TransformationConstant Value TransformationData Cleanse TransformationData Quality Rules TransformationDenormalize TransformationDistinct TransformationExpression TransformationFilter TransformationFunction TransformationsJoin TransformationMerge TransformationNormalize TransformationPassthru TransformationRest ClientRoute TransformationSequence Generator TransformationSort TransformationSources as TransformationsSubflow TransformationTree Join TransformationUnion TransformationWeb Service Transformation
PreviousXML/JSON File SourceNextAggregate Transformation

© Copyright 2025, Astera Software