Simple Loading Example - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software

Assume the following:

  • File to be loaded: 2010MarchSales_data.txt (assume current working directory)
  • Number of rows: 1000 rows encoded in text format
  • Delimiter: delimited by character "~"
  • Password: beehive
  • Destination table: sales_fact
  • Destination Aster Database: IP address 10.50.25.100
  • Username: assume default
  • Database: assume default

This is what you would type:

$ ./ncluster_loader -h  10.50.25.100  –w  beehive  -D  "~" sales_fact 2010MarchSales_data.txt

After successful completion, you will see the following output indicating 1000 rows loaded:

1000 tuples were successfully loaded into table customers.