Systems | Development | Analytics | API | Testing

January 2024

Delimited File Source in Astera Data Stack

In this video, we will be discussing how you can extract data from a delimited file using the Delimited File Source object in Astera. Delimited files are one of the most commonly used data formats and use specific characters or delimiters to separate records and indicate the structure of the table in which the data resides. Contents of the video.

XML JSON File Source in Astera Data Stack

In this video, we will be discussing how you can extract data from an XML JSON File Source using the XML JSON File Source object in Astera. XML JSON file source in Astera provides a high-speed reader for XML or JSON files in which the data is stored in a hierarchical format within several nodes and sub nodes. Contents of the video: Configure the object properties, including File Path, Schema Location, and other options. Generate XML Schema. Customizing XML Layout and Config Parameters. XML data preview.

Database Table Source in Astera Data Stack

In this video, we will see how a Database Table Source object works in Astera. The Database Table Source object is used to retrieve data from a database table. It offers incremental reads via change data capture, supports multi-way partitioning for enhanced performance, and allows customization with WHERE clauses and sorting options.