Upcoming Webinar

Join us for a FREE Webinar on Astera Intelligence: Leveraging AI for Automated Document Processing

Monday, 11th November, at 11 AM PT / 2 PM EST

Transformations Supported in Astera Centerprise Pushdown Optimization Mode2024-02-08T23:40:58+00:00

Transformations Supported in Astera Centerprise Pushdown Optimization Mode

 

Although Centerprise’s ETL engine deploys smart processing algorithms and a high degree of parallelism to optimize the scalability and speed of large data integration jobs, this three-step process can still act as a bottleneck to efficient data delivery.

 

In pushdown optimization mode, Centerprise leverages the native computing capacity of powerful RDBMS to perform all necessary operations in a dataflow. This setting allows Centerprise to load data directly into target databases from where it can be enriched and prepared in native SQL code using the intuitive drag-and-drop transformations already available on our platform. This optimized extract-load-transformation (ELT) process is ideally suited to large data sets.

 

In Astera Centerprise 8.0 we’ve added native SQL support for number of advanced transformations, thus allowing users to reap the full performance benefits of ELT in even the most complex dataflow pipelines. This comprehensive guide will take you through each of the data operations now supported in Centerprise pushdown optimization mode.

Privacy Policy

By submitting this form, you agree to be contacted by Astera Software and receive marketing materials.

Contact Us: +1-805-579-0004

Astera Intelligence: Leveraging AI for Automated Document Processing

Process Any Document, From Any Source, In Any Format, Anytime.

Nov 11th   |   11 am PT

SIGN UP NOW!