Archives of the TeradataForum
Message Posted: Wed, 07 May 2008 @ 22:33:52 GMT
I haven't followed this whole thread. But here is an example of a fastexport that creates the mload for you. You just have to customize with databasename replacement and including a logon statement.
.logtable STG_VOL.lt_tablename; .logon .... .begin export sessions 12 tenacity 4; .export outfile /emu/stage/tcy_stage/tablename_fexp.dat mode indicator format fastload MLSCRIPT /zebra/loads/daily/tcy/tcy_dyn_scripts/tablename_fexp.mdl; LOCK ROW FOR ACCESS SELECT a.* FROM databasename.Tablename a WHERE deal_discontinue_dt = date'9999-12-31' ; .end export; .logoff;
One of our DBA's (Tim Roche) created a table driven system that reads a Teradata table on the source Teradata. It then dynamically generates the fastexport script. Part of the cool thing it does is pull either all data or related sample based on keys like account_id or session_id. Thus all the data copied over to the other system is related IE all information for these randomly selected accounts.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|