Pushdown Optimization Mode in Centerprise

Pushdown Optimization Mode in CenterpriseSharjeel Ashraf2024-02-11T02:02:03+00:00

This whitepaper contains complete information about the Pushdown Optimization mode in Centerprise. It answers questions such as:

How is pushdown optimization mode based on ELT logic?
Under what scenarios it yields significant performance gains?
What are various types of pushdown optimization modes and how are they differentiated?
What are its limitations?

Interested in knowing answers to these questions?

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

img:is([sizes="auto" i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px;}img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}.wp-block-rank-math-toc-block nav ol{counter-reset:item;}.wp-block-rank-math-toc-block nav ol li{display:block;}.wp-block-rank-math-toc-block nav ol li:before{content:counters(item,".") " ";counter-increment:item;}@media screen and (max-width: 640px){body:not(.fusion-builder-ui-wireframe) .fusion-no-small-visibility{display:none !important;}body:not(.fusion-builder-ui-wireframe) .sm-text-align-center{text-align:center !important;}body:not(.fusion-builder-ui-wireframe) .sm-text-align-left{text-align:left !important;}body:not(.fusion-builder-ui-wireframe) .sm-text-align-right{text-align:right !important;}body:not(.fusion-builder-ui-wireframe) .sm-mx-auto{margin-left:auto !important;margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .sm-ml-auto{margin-left:auto !important;}body:not(.fusion-builder-ui-wireframe) .sm-mr-auto{margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .fusion-absolute-position-small{position:absolute;top:auto;width:100%;}}@media screen and (min-width: 641px) and (max-width: 1024px){body:not(.fusion-builder-ui-wireframe) .fusion-no-medium-visibility{display:none !important;}body:not(.fusion-builder-ui-wireframe) .md-text-align-center{text-align:center !important;}body:not(.fusion-builder-ui-wireframe) .md-text-align-left{text-align:left !important;}body:not(.fusion-builder-ui-wireframe) .md-text-align-right{text-align:right !important;}body:not(.fusion-builder-ui-wireframe) .md-mx-auto{margin-left:auto !important;margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .md-ml-auto{margin-left:auto !important;}body:not(.fusion-builder-ui-wireframe) .md-mr-auto{margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .fusion-absolute-position-medium{position:absolute;top:auto;width:100%;}}@media screen and (min-width: 1025px){body:not(.fusion-builder-ui-wireframe) .fusion-no-large-visibility{display:none !important;}body:not(.fusion-builder-ui-wireframe) .lg-text-align-center{text-align:center !important;}body:not(.fusion-builder-ui-wireframe) .lg-text-align-left{text-align:left !important;}body:not(.fusion-builder-ui-wireframe) .lg-text-align-right{text-align:right !important;}body:not(.fusion-builder-ui-wireframe) .lg-mx-auto{margin-left:auto !important;margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .lg-ml-auto{margin-left:auto !important;}body:not(.fusion-builder-ui-wireframe) .lg-mr-auto{margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .fusion-absolute-position-large{position:absolute;top:auto;width:100%;}}.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}@media screen and (max-height: 1024px){.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}}@media screen and (max-height: 640px){.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}}.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}.elementor-329 .elementor-element.elementor-element-3ba5feb7 .eael-adv-accordion .eael-accordion-list .eael-accordion-header.active .fa-toggle{transform:rotate(180deg);}.elementor-333 .elementor-element.elementor-element-7fcc3fd3 .eael-adv-accordion .eael-accordion-list .eael-accordion-header.active .fa-toggle{transform:rotate(180deg);}.elementor-331 .elementor-element.elementor-element-44e81b8a .eael-adv-accordion .eael-accordion-list .eael-accordion-header.active .fa-toggle{transform:rotate(180deg);}.elementor-332 .elementor-element.elementor-element-1b0b7d37 .eael-adv-accordion .eael-accordion-list .eael-accordion-header.active .fa-toggle{transform:rotate(180deg);}.elementor-65 .elementor-element.elementor-element-4acfa9a > .elementor-widget-container{--e-transform-rotateZ:0deg;--e-transform-rotateX:0deg;--e-transform-perspective:1000px;--e-transform-rotateY:-14deg;}.elementor-966 .elementor-element.elementor-element-4acfa9a > .elementor-widget-container{--e-transform-rotateZ:0deg;--e-transform-rotateX:0deg;--e-transform-perspective:1000px;--e-transform-rotateY:-14deg;}.elementor-800 .elementor-element.elementor-element-4acfa9a > .elementor-widget-container{--e-transform-rotateZ:0deg;--e-transform-rotateX:0deg;--e-transform-perspective:1000px;--e-transform-rotateY:-14deg;}.elementor-615 .elementor-element.elementor-element-4acfa9a > .elementor-widget-container{--e-transform-rotateZ:0deg;--e-transform-rotateX:0deg;--e-transform-perspective:1000px;--e-transform-rotateY:-14deg;}.elementor-widget-flip-box .elementor-flip-box__front .elementor-flip-box__layer__title{font-family:var(--e-global-typography-primary-font-family),Sans-serif;font-weight:var(--e-global-typography-primary-font-weight);background-color:white;color:#005ccc;padding-top:10px;padding-bottom:10px;padding-left:15px;inline-size:min-content;padding-right:15px;border-radius:10px;}a.elementor-flip-box__button.elementor-button.elementor-size-sm{margin-left:-23px !important;}.left-recent-post a:after{content:"";}.empower_data{line-height:1.31;font-size:63px;text-align:center;color:#fff;}.professional_txt{text-align:center;font-size:36px;line-height:1.31;color:#fff;}.m20{margin:20px;}.deliver_txt{font-size:18px;line-height:25px;color:#fff;font-weight:300;font-style:normal;font-stretch:normal;letter-spacing:normal;}.demo_btn{width:177px !important;height:61px !important;height:61px !important;margin-top:30px;padding:20px 0px 0px 0px;font-family:Open Sans;font-size:18px;font-weight:600;font-style:normal;font-stretch:normal;background:#0095da !important;}.started_btn{width:177px !important;height:61px !important;height:61px !important;padding:20px 0px 0px 0px;font-family:Open Sans;font-size:18px;font-weight:600;font-style:normal;font-stretch:normal;background:#f78834 !important;}.learn_btn{width:228px !important;height:68px !important;font-family:Open Sans;font-size:18px;font-weight:600;font-style:normal;font-stretch:normal;background:#f78834 !important;padding:25px 0px 0px 0px;}.get_start_btn{padding:25px 0px 0px 0px;width:314px !important;height:66px !important;}.req_btn_demo_btn_width_height{margin:30px 30px 0px 10px;width:243px !important;height:66px;padding:20px;}.content-container >p:hover{color:#fff !important;}.home_integration .fusion-content-boxes .fusion-column{margin-bottom:0px !important;}.home_integration .fusion-content-boxes .fusion-column{margin-bottom:0px !important;}.home_integration .fusion-content-boxes .fusion-column:nth-child(2n+1){background:-moz-linear-gradient(-45deg,rgba(201,201,201,.25) 0%,rgba(201,201,201,.25) 1%,rgba(201,201,201,.25) 15%,rgba(212,212,212,.25) 33%,rgba(255,255,255,1) 100%);background:-webkit-linear-gradient(-45deg,rgba(201,201,201,.25) 0%,rgba(201,201,201,.25) 1%,rgba(201,201,201,.25) 15%,rgba(212,212,212,.25) 33%,rgba(255,255,255,1) 100%);background:linear-gradient(135deg,rgba(201,201,201,.25) 0%,rgba(201,201,201,.25) 1%,rgba(201,201,201,.25) 15%,rgba(212,212,212,.25) 33%,rgba(255,255,255,1) 100%);filter:progid:DXImageTransform.Microsoft.gradient(startColorstr="#40c9c9c9",endColorstr="#ffffff",GradientType=1);}.home_integration .fusion-content-boxes .fusion-column:nth-child(3):hover,.fusion-content-boxes .content-wrapper-background:nth-child(3):hover{background-color:#0095da !important;}.home_image_carousel .fusion-carousel .fusion-carousel-item .fusion-image-wrapper{-webkit-filter:grayscale(100%);filter:grayscale(100%);}.home_image_carousel .fusion-carousel .fusion-carousel-item .fusion-image-wrapper:hover{-webkit-filter:grayscale(100%);filter:none;}.fusion-image-hovers .hover-type-liftup{overflow:hidden !important;}.fusion-image-hovers .hover-type-liftup:hover img{transform:none !important;}.transparent_btn{width:207px !important;height:56px !important;font-family:Open Sans;border:1px solid !important;background:none !important;padding:20px 25px 0px 20px;}.viewall_btn{margin:10px 5px;}.fusion_h2{margin-top:125px !important;}.line_text{top:92px !important;position:relative !important;}.center{text-align:center;}.mt-10{margin-left:10px;}.m5{margin:5px;}.industry_solution_box .content-box-heading{text-align:left !important;font-family:Open Sans !important;}.industry_solution_box .content-container >p:hover{color:#474747 !important;}.industry_solution_box .fusion-content-boxes{margin-bottom:0px !important;}.arrow_styling{color:#0095da !important;font-size:15px !important;}.get_strt_now_btn_width_height{margin:30px 30px 0px 10px;width:316px !important;height:66px;padding:25px;}.industry_solution_heading{line-height:1.2;font-size:44px;font-weight:600;font-style:normal;color:#fff;}.financial_heading_two{font-size:20px;font-weight:300;font-style:normal;color:#fff;}.financial_services_heading{font-size:45px;font-weight:300;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:left;color:#474747;}.wh-bullet-ellipse{color:#fff !important;display:inline-flex;justify-content:center;align-items:center;flex-direction:column;border-radius:50%;width:20px;height:20px;margin-top:3px;background-color:#0095da;vertical-align:top;}.wh-bullet-heading{width:88%;margin-left:8px !important;margin-bottom:0px !important;font-size:18px;font-weight:600;color:#0095da;display:inline-block;}.wh-bullet-para{margin-top:20px !important;font-size:17px;font-weight:300;color:#474747;}.bg_img_height{height:365px;}.req_demo_top{margin-top:70px;}.title_who_work{padding:55px 0px 0px 0px;font-family:Open Sans;font-size:50px;font-weight:300;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:center;color:#474747;}.read_more{margin-top:65px;font-family:Open Sans;font-size:17px;font-weight:600;color:#0095da !important;background-repeat:no-repeat;background-image:url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/optimized/rev-07863b0/www.astera.com/wp-content/uploads/2018/06/read-more-arrow.png");background-position-x:right;padding-right:46px;background-position-y:center;margin-bottom:40px;}.read_more.nitro-lazy{background-image:none !important;}.bg_image_arrow{display:inline-block !important;margin-top:6px;background-repeat:no-repeat;background-size:contain;background-image:url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/optimized/rev-07863b0/www.astera.com/wp-content/uploads/2018/06/read-more-arrow.png");margin-left:10px;vertical-align:middle;width:20px;height:20px;}.bg_image_arrow.nitro-lazy{background-image:none !important;}.wcp-carousel-main-wrap .slick-track a{display:inline-block !important;margin-top:20px !important;}.wcp-carousel-main-wrap .post-style-2 .wcp-content-wrap{padding:10px 15px 10px 15px !important;}#carousel-1331 .rpc-title{font-weight:600 !important;}.wcp-carousel-main-wrap .slick-track img{margin-top:-20px;}.industry_solution_heading{font-size:44px;font-weight:600;font-style:normal;color:#fff;}.intro_Lorem{text-align:center !important;font-size:31px;font-weight:300;font-style:normal;color:#474747;}.blue_heading_boxes{color:#474747;font-size:17px;font-weight:300;text-align:left;padding:0px 0px 0px;display:block;}.paragraph_boxes_styling{display:inline-block !important;color:#0095da !important;font-size:18px !important;font-weight:600 !important;text-align:left;padding:0px 10px 30px;}.explore-more h1,.explore-more p{display:inline-block;}.explore-more{margin:-5px;text-align:left;}.c_t_a{padding-top:45px;font-size:28px;font-weight:normal;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:center;color:#fff;}.c_t_a_btn{width:233px !important;height:60px;}.case_study_btn{padding:22px;font-weight:600;font-size:15px;font-family:Open Sans;font-style:normal;font-stretch:normal;background:#0095da !important;margin-top:40px;}.m-left{margin-left:-20px !important;}#padding_left{padding-left:0px !important;}.use_case_heading_banner{font-size:17px;font-weight:300;font-style:normal;font-stretch:normal;line-height:1.71;letter-spacing:normal;text-align:center;color:#474747;}.featured_resources_heading{font-size:50px;font-weight:300;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:center;color:#474747;}.use_case_box .content-box-heading{text-align:right !important;}.use_case_container .fusion-content-boxes.content-boxes-icon-boxed .content-wrapper-boxed{padding:0px !important;}.use_case_box .content-box-heading{padding:5px 30px !important;color:#fff !important;background-color:#f78834;display:inline-block;}.use_case_box .heading{text-align:right !important;}.use_case_box_para{height:160px;padding:22px;font-size:19px;font-weight:normal;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:center;color:#474747;}.bg_document{display:inline-block !important;background-repeat:no-repeat;background-size:contain;background-image:url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/optimized/rev-07863b0/www.astera.com/wp-content/uploads/2018/06/e-Forma-1.png");margin-left:-5px;vertical-align:middle;width:20px;height:20px;}.bg_document.nitro-lazy{background-image:none !important;}.document_heading{font-size:18px;font-weight:600;font-style:normal;font-stretch:normal;line-height:1.61;letter-spacing:normal;text-align:center;color:#114885;border-bottom:1px solid;}.block{display:block;}.edi_white_box .content-box-heading{text-align:center !important;font-family:Open Sans !important;}.edi_white_box .content-container >p:hover{color:#474747 !important;}.edi_white_box .fusion-content-boxes{margin-bottom:0px !important;}.data_integration_with_img{font-size:42px;line-height:47px;text-align:left;font-weight:300;color:#474747;}@media (max-width:480px){.data_integration{font-size:33px;line-height:47px;text-align:left;font-weight:300;margin-top:150px !important;color:#474747;}.data_integration_with_img{font-size:30px;line-height:47px;text-align:left;font-weight:300;color:#474747;}.block{display:initial !important;}.intro_Lorem{margin-right:10px !important;margin-left:10px !important;font-size:17px;}.industry_solution_heading{font-size:42px;}.case_study_btn{margin-top:0px !important;}.c_t_a{font-size:25px;}.salesforce_banner_heading{font-size:36px;}}@media (max-width: 768px){.viewall_btn{margin:10px 0px;}}@media only screen and (max-width: 800px){.industry_solution_box .fusion-content-boxes.content-boxes-icon-boxed .content-box-column,.fusion-content-boxes.content-boxes-icon-on-top .content-box-column{margin-bottom:55px;width:80%;margin:55px auto;margin-top:0px;}}form.wpcf7-form.sent .fusion-slider-loading{display:none !important;}.wpcf7-form .wpcf7-mail-sent-ok{text-transform:inherit;}.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{display:inline-block;overflow:hidden;position:absolute;left:309px;top:30px;text-align:right;}.applynow-form-container .field-container .field input[type=file]{margin-left:-130px;display:block;font-size:1vw;color:#c1c1c1;font-family:Open Sans;font-weight:300;text-align:right;width:299px;text-indent:-150px;}.applynow-form-container .field-container .field.file-upload br{display:none;}.applynow-form-container .field-container .field.file-upload{text-align:center;}.applynow-form-container .field-container .field.file-upload>label{position:static;display:inline-block;width:289px;height:80px;margin-top:40px;}@media screen and (max-width: 768px){.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{display:block;clear:both;position:static;margin-top:-50px;}.applynow-form-container .field-container .field input[type=file]{margin-left:-100px;}}@media screen and (min-width: 769px) and (max-width: 800px){.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{position:absolute;left:370px;}.applynow-form-container .field-container .field input[type=file]{margin-left:-80px;}}@media screen and (min-width: 801px){.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{top:16px;left:271px;}.applynow-form-container .field-container .field input[type=file]{margin-left:-70px;}}@media screen and (min-width: 1168px){.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{top:26px;left:276px;}.applynow-form-container .field-container .field input[type=file]{margin-left:-70px;}}@media only screen and (max-width: 800px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:16.19vw !important;}}@media only screen and (max-width: 640px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;width:33%;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:21.19vw !important;}}@media only screen and (max-width: 425px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;width:94%;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:31.19vw !important;}}@media only screen and (max-width: 375px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;width:97%;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:36.19vw !important;}}@media only screen and (min-width: 426px) and (max-width: 480px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;width:97%;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:28.19vw !important;}}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{margin-top:0;line-height:7 !important;}.alertmsg div.wpcf7-response-output{margin-top:0;margin-bottom:2em;margin-right:2em;margin-left:2em;}.alertmsg span.fusion-alert-content{font-weight:600;}.fusion-icon-googleplus{display:none !important;}@media only screen and (max-width: 1200px){.single-career #main{padding-left:15px !important;padding-right:15px !important;}.single-career p.industry_solution_heading{padding:0 30px !important;}}.page-id-11371 .wcp-post-contents.rpc-content{min-height:136px;}.applynow-form-container .field-container .field.file-upload>label{top:0 !important;left:0 !important;}.wpcf7-form .wpcf7-mail-sent-ok span.alert-icon{display:none;}.fusion-alert-content-wrapper i.fa-lg.fa.fa-check-circle{margin-right:5px;}.fusion-alert-content-wrapper span.fusion-alert-content{text-transform:none;}.blue-strip-container .blue-strip .strip-button-container .strip-button:hover{color:#0095da !important;}.fusion-fullwidth.fullwidth-box.blue-strip-container.industry-solution-blue-strip-container.mt-30.nonhundred-percent-fullwidth.non-hundred-percent-height-scrolling +p{margin:0;}#wpls-logo-showcase-slider-1 .wp-post-image{visibility:visible !important;opacity:.6;}#wpls-logo-showcase-slider-1 .wp-post-image:hover{opacity:1;}.width-100 .nonhundred-percent-fullwidth +p{margin:0;}.single .category-edi-transaction-set .fusion-sharing-box,.category-edi-transaction-set .fusion-post-title-meta-wrap{display:none;}.fusion-author .fusion-author-title,.fusion-header-tagline,.fusion-modal .modal-title,.fusion-modal h3,.fusion-pricing-table .pricing-row,.fusion-pricing-table .title-row,.fusion-title h3,.fusion-widget-area h3,.main-flex .slide-content h3,.post-content h3,.project-content h3,.sidebar .widget h3{font-family:Open Sans !important;}@media screen and (max-width: 1150px){.parent-pageid-12 .main-menu-banner{min-height:500px;}}.parent-pageid-12 .req_btn_demo_btn_width_height{margin:30px 0 0;}.parent-pageid-12{overflow-x:hidden;}.parent-pageid-12 .fusion-imageframe,.wpsisac-slick-slider.design-4 .slick-image-slide img{width:100%;}@media screen and (max-width: 800px){.resource-search-container .fusion-columns .fusion-column.col-sm-6{width:100% !important;}}@media screen and (min-width: 641px) and (max-width: 800px){.page-id-344 .fusion-layout-column:first-child{margin-right:4% !important;}}@media screen and (max-width: 800px){.career-card{min-height:inherit !important;padding-bottom:25px;}}.post-type-archive-news .dl-blog-compact-list .dl-post{margin:15px 0 15px;}.post-type-archive-news .dl-blog-compact-list{padding-left:15px;padding-right:15px;}.slide-wrap.wp-medium-12.wpcolumns .slider-content-right.wp-medium-5.wpcolumns{display:none;}.slide-wrap.wp-medium-12.wpcolumns .slider-content-left.wp-medium-7.wpcolumns{width:100%;}.slide-wrap.wp-medium-12.wpcolumns .slider-content-left.wp-medium-7.wpcolumns img.img-responsive,.slide-wrap.wp-medium-12.wpcolumns .slider-content-left.wp-medium-7.wpcolumns span{width:100%;}@media screen and (min-width: 801px){.social-links-footer{padding-right:136px;}iframe#launcher{bottom:15px !important;}}ul#menu-pricing a:before{content:none;}body ul#menu-pricing li{padding:0;}ul#menu-pricing a,ul#menu-pricing a:hover{font-size:14px;font-weight:400;color:#575757;}section#nav_menu-2 h4.widget-title{margin-bottom:0;line-height:1.4;}@media (max-width: 800px){section#nav_menu-2 *{text-align:center;}}ul#menu-pricing .current-menu-item a{color:#646464 !important;font-weight:700;}body .applynow-form-container .field-container .field.filename{font-size:13px !important;width:84% !important;margin-left:8% !important;margin-right:8% !important;margin-bottom:0 !important;line-height:1 !important;text-indent:0 !important;float:none !important;clear:both !important;height:auto !important;}body .applynow-form-container .field-container.applynow-upload{display:block !important;}body .applynow-form-container .field-container .field.file-upload{width:84% !important;margin-left:8% !important;margin-right:8% !important;margin-bottom:11px !important;position:relative !important;}body .applynow-form-container .field-container .field.file-upload > label{}body .applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{margin:0 !important;}.rmft{position:absolute;bottom:5.35%;left:0;}.rmlm{position:absolute;bottom:4.5%;left:0;}.search .dl-header{max-width:inherit !important;}.search .dl-header .dl-nav-container{display:inherit !important;}.search .fusion-fullwidth{background:#fff;padding:0;}.search #main .fusion-row,.search #slidingbar-area .fusion-row,.search .fusion-footer-copyright-area .fusion-row,.search .fusion-footer-widget-area .fusion-row,.search .fusion-page-title-row,.search .tfs-slider .slide-content-container .slide-content{max-width:1100px !important;}.search .fusion-footer{display:block !important;}.search .fusion-footer-widget-area .fusion-row{max-width:100% !important;}.search .fusion-footer-copyright-area .fusion-row{max-width:100% !important;}.search input[type="text"],.search input[type="email"],.search input[type="url"],.search input[type="password"],.search input[type="search"],.search input[type="number"],.search input[type="tel"],.search input[type="range"],.search input[type="date"],.search input[type="month"],.search input[type="week"],.search input[type="time"],.search input[type="datetime"],.search input[type="datetime-local"],.search input[type="color"],.search textarea,.search .hbspt-form .field select{padding:2px 10px !important;}.search .dl-header .dl-main-menu>.dl-menu>li>.sub-menu{z-index:99;}.single-tabcont .inner-tab-cont .resources-badge p{color:#fff !important;background:#005ccc !important;}.single-tabcont .inner-tab-cont a.read-more-blog{display:none;}.ekit-wid-con .ekit_testimonial_style_2{background-color:#eff5ff !important;}.wpcf7-captchar,.wpcf7-form .wpcf7-date,.wpcf7-form .wpcf7-number,.wpcf7-form .wpcf7-quiz,.wpcf7-form .wpcf7-select,.wpcf7-form .wpcf7-text{width:320px !important;height:40px !important;top:6826px !important;left:659px !important;gap:0px !important;border-radius:11px 11px 11px 11px !important;border:1px 0px 0px 0px !important;opacity:0px !important;color:#aaadb4 !important;}.wpcf7-form textarea{border-radius:11px 11px 11px 11px !important;}.wpcf7-form input[type="submit"],.wpcf7-submit:hover{background:#005ccc !important;border-radius:6px 6px 6px 6px !important;}.dl-header.over{box-shadow:none !important;}.fusion-footer{display:none !important;}#launcher{display:none !important;}.dl-header{max-width:1279px !important;margin:auto !important;position:inherit !important;}body{margin-top:0 !important;}#main .fusion-row,#slidingbar-area .fusion-row,.fusion-footer-copyright-area .fusion-row,.fusion-footer-widget-area .fusion-row,.fusion-page-title-row,.tfs-slider .slide-content-container .slide-content{max-width:1196px !important;}.hs-form-field label{font-size:13px !important;position:inherit !important;color:#404040 !important;right:inherit !important;font-weight:400 !important;padding-bottom:6px !important;display:block !important;min-height:25px !important;top:inherit !important;}.hbspt-form form{padding:0 !important;}.h-img{margin:0 -18px 18px !important;}span.hs-form-required{padding-left:4px !important;color:#f00 !important;}.hbspt-form .field input,.hbspt-form .field select,.hbspt-form .field textarea{width:100% !important;background:#f7f7f7 !important;border:1px solid #c9c9c9 !important;font-size:15px !important;border-radius:3px !important;min-height:54px !important;}input[type="text"],input[type="email"],input[type="url"],input[type="password"],input[type="search"],input[type="number"],input[type="tel"],input[type="range"],input[type="date"],input[type="month"],input[type="week"],input[type="time"],input[type="datetime"],input[type="datetime-local"],input[type="color"],textarea,.hbspt-form .field select{color:#666 !important;padding:3px !important;}.hs_phone.hs-phone label{position:relative !important;left:-39% !important;}.hs_submit input.hs-button{position:relative !important;color:#fff !important;border:1px solid #f78834 !important;background-color:#f78834 !important;font-size:17px !important;font-weight:300 !important;padding:.8em 2em !important;cursor:pointer !important;border-radius:3px !important;}.hbspt-form input[type="button"],body .hbspt-form input[type="submit"]:hover{color:#f78834 !important;}.hbspt-form{padding:0 18px 22px !important;}.prv-notice{margin-top:0 !important;margin:18px 0 0 !important;line-height:1.25 !important;font-size:12px !important;color:#828282 !important;}.prv-notice{margin:0 22px !important;}.prv-notice +.prv-notice{margin-top:8px !important;}body .hbspt-form fieldset +fieldset .input{margin-top:0 !important;}.hbspt-form fieldset.form-columns-3 .hs-form-field:first-child label,.hbspt-form fieldset.form-columns-3 .hs-form-field:last-child label,.hbspt-form fieldset.form-columns-3 .hs-form-field:nth-child(2) label{top:0 !important;}.hbspt-form fieldset +fieldset .hs-form-field,.hbspt-form fieldset +fieldset .popup-n{margin-top:18px !important;}.hs_submit{margin-top:27px !important;}label.hs-error-msg{color:red !important;font-size:12px !important;padding:5px 0 !important;font-weight:300 !important;}.hs-error-msgs{margin:0 !important;padding:0 !important;list-style-type:none !important;line-height:1 !important;}body{background:#fff url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/optimized/rev-07863b0/www.astera.com/wp-content/uploads/2020/04/blue-bg.jpg") no-repeat center 70px !important;background-size:cover !important;}body.nitro-lazy{background-image:none !important;}#main,#wrapper{background:transparent !important;}.dl-header .dl-nav-container{display:none !important;}#main .fullwidth-box .fusion-row{position:relative !important;}.h-tel p span{background:url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/optimized/rev-07863b0/www.astera.com/wp-content/uploads/2020/04/contact.png") no-repeat !important;background-position:left center !important;padding-left:44px !important;font-weight:400 !important;}.h-tel p span.nitro-lazy{background-image:none !important;}.h-tel{position:absolute !important;top:-122px !important;right:0 !important;margin:0 !important;}.h-tel p{margin:0 !important;}.hbspt-form .field input,.hbspt-form .field select,.hbspt-form .field textarea{width:100% !important;}.hs_phone.hs-phone label{width:111px !important;}.hbspt-form .field select{padding-left:0 !important;}@media screen and (max-width: 800px){.h-tel{display:none !important;}}@media screen and (max-width: 480px){.hs_country4{width:48% !important;float:left !important;}.hs_testfield__d{width:17% !important;float:left !important;}.hs_phone{width:35% !important;float:left !important;}.hs_phone.hs-phone label{left:-52% !important;}}.wp-block-audio :where(figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme .wp-block-audio :where(figcaption){color:rgba(255,255,255,.65);}.wp-block-audio{margin:0 0 1em;}.wp-block-code{border:1px solid #ccc;border-radius:4px;font-family:Menlo,Consolas,monaco,monospace;padding:.8em 1em;}.wp-block-embed :where(figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme .wp-block-embed :where(figcaption){color:rgba(255,255,255,.65);}.wp-block-embed{margin:0 0 1em;}.blocks-gallery-caption{color:#555;font-size:13px;text-align:center;}.is-dark-theme .blocks-gallery-caption{color:rgba(255,255,255,.65);}:root :where(.wp-block-image figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme :root :where(.wp-block-image figcaption){color:rgba(255,255,255,.65);}.wp-block-image{margin:0 0 1em;}.wp-block-pullquote{border-bottom:4px solid;border-top:4px solid;color:currentColor;margin-bottom:1.75em;}.wp-block-pullquote cite,.wp-block-pullquote footer,.wp-block-pullquote__citation{color:currentColor;font-size:.8125em;font-style:normal;text-transform:uppercase;}.wp-block-quote{border-left:.25em solid;margin:0 0 1.75em;padding-left:1em;}.wp-block-quote cite,.wp-block-quote footer{color:currentColor;font-size:.8125em;font-style:normal;position:relative;}.wp-block-quote:where(.has-text-align-right){border-left:none;border-right:.25em solid;padding-left:0;padding-right:1em;}.wp-block-quote:where(.has-text-align-center){border:none;padding-left:0;}.wp-block-quote.is-large,.wp-block-quote.is-style-large,.wp-block-quote:where(.is-style-plain){border:none;}.wp-block-search .wp-block-search__label{font-weight:700;}.wp-block-search__button{border:1px solid #ccc;padding:.375em .625em;}:where(.wp-block-group.has-background){padding:1.25em 2.375em;}.wp-block-separator.has-css-opacity{opacity:.4;}.wp-block-separator{border:none;border-bottom:2px solid;margin-left:auto;margin-right:auto;}.wp-block-separator.has-alpha-channel-opacity{opacity:1;}.wp-block-separator:not(.is-style-wide):not(.is-style-dots){width:100px;}.wp-block-separator.has-background:not(.is-style-dots){border-bottom:none;height:1px;}.wp-block-separator.has-background:not(.is-style-wide):not(.is-style-dots){height:2px;}.wp-block-table{margin:0 0 1em;}.wp-block-table td,.wp-block-table th{word-break:normal;}.wp-block-table :where(figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme .wp-block-table :where(figcaption){color:rgba(255,255,255,.65);}.wp-block-video :where(figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme .wp-block-video :where(figcaption){color:rgba(255,255,255,.65);}.wp-block-video{margin:0 0 1em;}:root :where(.wp-block-template-part.has-background){margin-bottom:0;margin-top:0;padding:1.25em 2.375em;}

Automated EDI files processing - Healthcare

WHAT’S NEW

Introducing Astera 10.5

Astera Reportminer wins again

Astera Data Academy

Start Here

Charting Business Value Through Data Driven Decisions

Data-driven Finance with Astera Data Stack

Company

Partners

Customers

Support