Loading a pipe delimited file to a Database.
Posted: Mon Mar 01, 2010 1:40 pm
I have a large pipe delimited file that I need to load into a teradata database.
The file is approx 1,000,000 records long and 150 fields wide.
What I would like to do is write any error records to a error log txt file and keep the load running until the end.
Is this possible? If so, what are the steps?
Thank You,
Corey
The file is approx 1,000,000 records long and 150 fields wide.
What I would like to do is write any error records to a error log txt file and keep the load running until the end.
Is this possible? If so, what are the steps?
Thank You,
Corey