FASTEXPORT with MLSCRIPT option

Tools
Enthusiast

FASTEXPORT with MLSCRIPT option

I have exported 809GB data to data file using fast export with MLSCRIPT option sucessfully. I imported to table again using ml script which is generated by fast export script. I did the row count validation, found 1 record mismatch.

fastexport script:

=========================

.logtable db.log;

.logon xxx/xxxx,xxx;

.BEGIN EXPORT ;

.EXPORT OUTFILE test.dat

 MLSCRIPT test_exp.mlds;

SELECT * FROM DB.TABLE;

.END EXPORT;

.LOGOFF;

======================

Note: In export log row count is correct. In import log " Candidate records considered: 132131233" (count is 1 less). NO records are inserted in error tables.

May I know the possilbe reason.

Thanks in advance.

Regards,

Gnana Reddy.

3 REPLIES
Teradata Employee

Re: FASTEXPORT with MLSCRIPT option

Hi,

Can you send us the FEXP job output and the corresponding FEXP-generated MLOAD job output?

Thanks!

Enthusiast

Re: FASTEXPORT with MLSCRIPT option

Hi,

Can not share the o/p file is in binary format also it is size of 1.6TB.

Kindly let me know the possible reasons for not loading ONE record when I imported the data using MLScript which has generated by Fastexport with MLSCRIPT option. This I noticed only for large tables (e.g... more than 600GB TD tables). For small tables loaded perfectly.

Thank You,

Gnana Reddy.

Teradata Employee

Re: FASTEXPORT with MLSCRIPT option

Hi,

I only need the FEXP job output and the corresponding FEXP-generated MLOAD job output. These files should not be as large as 1.6TB.

The huge data file is not needed. At least, please share with us the table definition of your target table.

Thanks!