Archives of the TeradataForum

Message Posted: Thu, 11 Jun 2009 @ 13:45:11 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I think the way the connections are made make the Mload thinks one file at a time. The import in file will treat as one input file. If you are loading multiple files from the same Input file (SQL table) it may work but I am not sure. Ole DB acts different. The best way is to load one table at a time sequentially or even parallel depending on how many mloads you can run. It worked well for me. I had scheduled jobs within the batch that imported tables without any issue. Once you have all the raw data, use simple Bteq for transformation.

I think there is one more option that you can explore. It is the Microsoft SSIS. From this package you can directly export data that use Microsoft native connectivity to Teradata. If I remember right, they made some kind partnership with Teradata for this. Worth looking. Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>