CODEWITHSUNDEEP
analyticssasbusiness-intelligenceteradataparaccel
Macbook
Macbook

Reputation: 135

What is the FastLoad (in Teradata) equivalent for ParAccel?

I have recently shifted from Teradata to ParAccel and I use my BI DBMS with SAS environment. Teradata has this utility called FastLoad for loading large datasets fast and more efficiently. I often have to make use of this utility to transfer datasets from SAS libraries to Teradata. I would like to know if there's a similar utility/command/function for ParAccel as well. Any help will be appreciated.

Upvotes: 2

Views: 371

Answers (2)

Diego
Diego

Reputation: 36166

you should look at the copy command

psql $DATABASE -c "copy destination_table() from 'local' with parallel delimiter ',' truncatecolumns MAXERROR 100000"

Upvotes: 0

user1949234
user1949234

Reputation: 46

yes, ParAccel does have a bulk loading utility and also has a ODBC module for SAS to load data directly. I would encourage you to reach out to ParAccel support!!.

Upvotes: 3

Related Questions