All Forums Tools
balu_td 22 posts Joined 03/13
05 Sep 2013
Fast Export and MLoad

I have a requirement i need to export a data from one table using fast export  Parallel load it into a table using MLOAD.
I can write seprated Fast export and Mload but As the table is huge and i dont want waste unix space as the fast export creates the big file.
Can we load it like a queue..
Eg: When fast exports writes one record into file and it's has to be loaded into the table using Mload..
Suggestions Plz....

dhirajpalse 36 posts Joined 01/08
08 Sep 2013

It is never possible to load tables row by row in the way you want as MLOAD and FastExport have block level operations. Also file should be completely ready to laod in order to start MLOAD.
You can achieve it through single TPT script with use of EXPORT and UPDATE operators. You can refer to TPT manual to create such script OR brwse through this forum for sample script.


ThomasNguyen 30 posts Joined 04/09
10 Sep 2013

I think you can use NP AXMOD. MultiLoad reads from the NP and FastEXport writes to NP.
You can use regular named pipe but restarts don't work.

balu_td 22 posts Joined 03/13
24 Sep 2013

Thanks Dhiraj and Thomas,
Thomas Could please explain me in brief or any place i can get more infomation about NP AXMOD.

ThomasNguyen 30 posts Joined 04/09
27 Sep 2013
islanderman 40 posts Joined 03/14
02 May 2014

Hoping someone can give me guidance.  Currently we have large loads of data being inserted to Teradata via a perl script from Linux RedHat.  The insertion is line by line so it takes hours to load.  I was able to install tdicu, tdodbc, TeraGSS by downloading the tar files from this site.  I was able to configure DBD::ODBC to connect to the Teradata DB and the insertion works fine.  I've been told to use JDBC for Mload or Bteq or Fastload, but I'm not familiar enough with Java.  I've been told to work with TPT 14, which is part of TTU, but I don't know how to get the software for Linux.  
First of all, I assume that all of the Mload/Fastload/Bteq is all part of the TTU package, is that correct?
If I happen to get the software can I use perl to execute the Mload/Fastload/Bteq script?
Any help would be appreciated.

feinholz 1234 posts Joined 05/08
02 May 2014

If you are going to be using our load/unload tools for the first time, you should use TPT. It is the suite of load/unload tools going forward.
TPT is part of TTU and can be found in the same media as the rest of the software.


You must sign in to leave a comment.