Stack Overflow
Stack Overflow

Questions tagged [fastexport]

FastExport is a utility that exports large data sets from Teradata tables or views to a client system for processing, generating large reports, or for loading data into a smaller database.

FastExport is a utility that exports large data sets from Teradata tables or views to a client system for processing, generating large reports, or for loading data into a smaller database.

21 questions
6
votes
6 answers

migrate Hg to Git via "fast-export" in Windows

I have a project having mercurial HG code source management,and try to migrate it on a VSTS/Git platform. I read that there is a tool for doing that, "fast-export"... So I tried but not did't achieve to do it working in Windows... Say I have…
serge
  • 13,940
  • 35
  • 121
  • 205
2
votes
1 answer

How to verify history after Mercurial to Git migration

I have converted a Mercurial project ( which has huge history) to Git project using fast-export tool. Now I want to verify that it didn't missed any history in the migration, is there any automation way to cross-check the history?
andrew
  • 21
  • 1
1
vote
0 answers

convert mercurial to git with not UTF8 characters

I have many mercurial repositories and I try to convert them to git repo. I used fast-export https://github.com/frej/fast-export and everything was good, but some of my mercurial repo have files with russian letters. It's huge repositories with…
supportth
  • 29
  • 4
1
vote
1 answer

Parse a text file using batch script and remove the first 2 characters from each line

I have been trying to parse the data from a text file that is generated by Teradata fast export utility. The data looks like this: Type2LRF|84|249 Job3|86|327 StageTOStageBackUp|85|327 When I have checked the character count of the garbage…
Teja Goud Kandula
  • 1,462
  • 13
  • 26
1
vote
0 answers

Issue when setting a cell value string with emoji, java dhatim/fastexcel

Code is executed without error, but when i open the xlsx file i see the following I changed the xlsx file to zip, and opened xl/sharedStrings.xml file This symbols where there �� Here is sharedStrings.xml The file
Andranik
  • 156
  • 1
  • 2
  • 10
0
votes
0 answers

Fetching Char(1) column with Informatica Export mode returning error

I am using TPT FastExport in Informatica source. In the source Teradata table, there is a column with datatype char(1). When I run the workflow, I am getting an error as Source column data length is 3 but the Target column data length is 6. I am not…
Jegatheesan
  • 105
  • 2
  • 8
0
votes
0 answers

Teradata JDBC FastExport performance

I'm ingesting the content of a Teradata table that contains ~700,000,000 rows with JDBC FastExport. My code (simplified) is the following: Class.forName("com.teradata.jdbc.TeraDriver") val url =…
Maxence Cramet
  • 552
  • 1
  • 5
  • 17
0
votes
0 answers

how to pass variables into Teradata fastexport

my Bteq file code(test_bteq) is select * from students where student.id between &start and $end. the bteq sql is scheduled everyday and these 2 variables from 2 columns of a configuration table(tab_conf). I need to use &start and $end variables in…
xiaojzhu
  • 1
0
votes
0 answers

How to use Jdbc FastExport to transfer data from teradata to Mariadb

I have a big table in teradata with around 10 million rows. Need to migrate this table from teradata to mariadb on a daily basis. I read about fast export. Can it be use here programatically in java application in this case.
pvjhs
  • 549
  • 1
  • 9
  • 24
0
votes
0 answers

Disable logs in MultiLoad and FastExport - Teradata

I'm working with a script in python that will first create mload or fastexport files depending on parameters and then within the script I start those files to insert/export data. result = subprocess.run(["{0} < {1}".format(file_type,…
Aleksander Lipka
  • 354
  • 1
  • 9
  • 20
0
votes
1 answer

BigQuery equivalent of FastExport

I have multiple uses cases of Teradata fast export to extract data for various reports & feed to some mainframe jobs (Binary data). In BigQuery I have a way to run **bq extract **, however options are limited. I would like to know is there any…
Navneet Kumar
  • 3,732
  • 2
  • 18
  • 25
0
votes
0 answers

Query execution is slow in Teradata FastExport compared to Default Connection

I have a small doubt on how to use fastexport in production environment. I have a million rows file and am using fastload to upload it to TD which is taking almost a minute and doing some business logic and when i use fastexport for downloading the…
paul
  • 3
  • 2
0
votes
1 answer

Is it possible to combine two different database utility like Teradata's Fast export to Greenplum's GPloader?

Usually, I use a JDBC connection with some ETL tool to move data from one database(i.e Teradata) to another database(i.e Greenplum). However, both of these databases comes with inbuilt utilities which can load/export huge amounts of data very fast,…
Vijay Shekhawat
  • 3
  • 5
0
votes
1 answer

teradata studio sorted export using Fastexport

Is it possible to export data from Teradata Studio in a sorted order using Fastexport? We are using Teradata Studio version 16.10. Thank you.
Rusty75
  • 477
  • 7
  • 19
0
votes
1 answer

How can we export 2 TB Teradata(Table Size) into Google Cloud Storage

We have used FastExport utility but it is not efficient to process that huge data . Which should be best way to export that much data .We want the most efficent & fast way to do that .
DataVishesh
  • 197
  • 1
  • 5
1
2