With Teradata Studio Express
Here is how we do it for Studio Express:
- Go to data explorer.
- Search for the database under which the required table is located.
- Explore the database.
- Right-click on the table, Name | Data | Export Data.
- The Wizard will come up; select the destination file where the data needs to be written in.
- Select the option of Export Data Format from File options.
- Once the data is written to the file, you will get a success message.
- Open the file to verify the data.
With Teradata SQLA
- Select the Export Data option from the File tab.
- Execute the select query from which you need to export the data.
- As you hit F5 for execution, a window prompt will appear. Save the file with the required name and format.
- Your ...