Introduction to Teradata FastLoad Script catalog sources
You can use Metadata Command Center to extract metadata from a source system.
A source system is any system that contains data or metadata. For example, Teradata database is a source system from which you can extract metadata through a Teradata FastLoad Script catalog source with Metadata Command Center. A catalog source is an object that represents and contains metadata from the source system.
Before you extract metadata from a source system, you first create and register a catalog source that represents the source system.
When Metadata Command Center extracts metadata, Data Governance and Catalog displays the extracted metadata and its attributes as technical assets. You can then perform tasks such as analyzing the assets, viewing lineage, and creating links between those assets and their business context.
You can only extract metadata using this catalog source.
Extraction and view process
To extract metadata from a source system, configure the catalog source and run the extraction job in Metadata Command Center. Then view the results in Data Governance and Catalog.
The following image shows the process to extract metadata from a script:
After you verify prerequisites, perform the following tasks to extract metadata from Teradata FastLoad Script:
1Register a catalog source. Create a catalog source object, select Teradata FastLoad Script, and specify values for connection properties.
2Configure capabilities. A capability is a task that Metadata Command Center can perform, such as metadata extraction.
3Optionally, associate stakeholders. Associate users with technical assets, giving the users permission to perform actions determined by their roles.
4Run or schedule the catalog source job.
5Optionally, assign a connection to referenced source system assets.
About the Teradata FastLoad Script catalog source
You can use the Teradata FastLoad Script catalog source to extract metadata from script files that define transformations on a Teradata database source system.
Teradata FastLoad Script is a utility that you can use to quickly load large amounts of data in an empty table on a Teradata database.
Compatible connectors
Before you configure the Teradata FastLoad Script catalog source, you must connect to the Teradata database source system.
Use the Teradata connector to connect to the Teradata database source system. For information about configuring a connection, see Administration.
Extracted metadata
You can use the Teradata FastLoad Script catalog source to extract metadata from the Teradata database source system.
Teradata FastLoad Script is a set of commands and Teradata SQL statements stored in files that you can use to run sequential scripts.
Metadata Command Center extracts the following metadata from a Teradata database source system:
•Calculation
•Folder
•Script
•Statement
Input files
You can extract metadata from Teradata FastLoad input files.