Transferring a csv file into my data lab. data is not fully loaded?

Teradata Studio
Enthusiast

Transferring a csv file into my data lab. data is not fully loaded?

 Hi i have a csv file on my sharedrive that i am trying to load into my data lab. the csv file has about 117,000 rows. when i upload the file, only 14,000 rows were uploaded. i am using the smart load wizard in Teradada studio. what could be the issue? thanks
1 REPLY 1
Teradata Employee

Re: Transferring a csv file into my data lab. data is not fully loaded?

There is a Transfer History View that contains a table of data transfer results. If you are on Studio, switch to the Data Transfer perspective. At the bottom is the Transfer History View. Select the item for your data lab load and click the Job Details button. If you are on Studio Express, go to Window>Show View and open the Transfer History View.

The problem could be that there is bad data in the csv file. 

 

-francine