Command—loaddata for Trillium Files - trillium_discovery - trillium_quality - 17.2

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:53:20.448228

You can create an entity using Trillium files that are created as output by the Trillium Quality application.

Before you issue the loaddata command, create a loader connection for your "Trillium" data source. The loader connection specifies where the data source files are located and allows the loaddata command to connect to the data source and initiate the data import process.

Syntax

loaddata <loader_connection> datafile <filename> 

where,

<loader_connection>

Name assigned by the repository administrator to the loader connection.

<filename>

Name of the Trillium file that contains the data.

Optional Parameters

Parameter

Description

username <user_name>

User ID required to validate the connection to the data source.

Use this parameter if a login name and password are required.

Do not use the username and password parameters if the mtb_admin user is the data file owner.

password <password>

Password required to validate the connection to the data source.

Use this parameter if a login name and password are required.

schemafile <filename>

Name of the schema file that corresponds to the delimited file you specified as the data file.

jobname <job_name>

Job ID or name of the data load job.

skip <number>

Number of rows to skip before starting to import data rows. All rows after the skipped rows will be loaded to the repository. For example, if your file has 300 rows and you select to skip the first 99, the system will load 200 rows, starting with the 100th row.

first <number>

Number of records from the beginning of the file (for example, the first 1000 records) to load.

random <percentage>

The degree to which you want to randomly sample a percentage of records from the file.

Example

This command uses a loader connection called qualconn and creates an entity by loading data from the testqual file.

loaddata qualconn datafile testtril schemafile testqual.ddt jobname qualityload1