Export

Teradata Studio

Export

Hi,

 

When I come to export data from a table, it duplicates the size of the field. Why.

 

With Teradata studio v.16.10.20

2 REPLIES 2
Teradata Employee

Re: Export

What is the database version?

 

Highlighted
Teradata Employee

Re: Export

Hi,

Are you talking about Copy Object Wizard from Table--> Data-->Export Data..-->Teradata - Teradata?

And (FilterRows.png) "Column Names / Types" which is not editable to the user for selecting another data type before copy the data?  

FilterRows.png

If your answer is YES. The following details may help you.

The wizard is for to "Filter the rows based the values" before copy starts. which means if a user wants to load a few rows based on values he can set the filters here.

**Studio does not support to change data types while Export from the table to the table, it will use the same data types.

-------------------------------------------------------

If you would like to change the data types before loading the data into a new table.

There is a workaround in the Studio: you need to export the data into an excel file and load into a new table using (Smart load). Find the images (Smartload-Launch.png,ClicktoChooseDatatype.png,ColumnTypeSelection.png).

 

Hope this helps! if not, Please elaborate your question. Thanks

 

Smartload-Launch.png

 

 

 

 

 

 

ClicktoChooseDatatype.pngColumnTypeSelection.png