Systems | Development | Analytics | API | Testing

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.

What is a Data Mart? Design, Examples, and Implementation Explained

Unlike a data warehouse that stores enterprise-wide data, a data mart includes information related to a particular department or subject area. For instance, a sales data mart may contain data related to products, clients, and sales only. Read this blog to develop a better understanding of these departmental data repositories.