Teradata enterprise Vs Multiload stage
Posted: Mon Apr 06, 2009 2:07 am
Hi,
Datastage version: 8.0.1
I have a requirement to export ~500 million records from teradata. There are two tables that I need to join to extract the data. The source tables are partitioned.
Could you pls let me know if its better to use Teradata EE stage against MultiLoad stage.
The documentation and some of the forum questions suggests both these stages when used as the Source Stage will internally use the FastExport utility.
How different is the Teradata connector stage when compared to the above two since connector stage also uses FastExport internally. IBM suggests Connector stages to be the future. Does this mean EE and Multiload stages could be deprecated in future.
Thanks
Datastage version: 8.0.1
I have a requirement to export ~500 million records from teradata. There are two tables that I need to join to extract the data. The source tables are partitioned.
Could you pls let me know if its better to use Teradata EE stage against MultiLoad stage.
The documentation and some of the forum questions suggests both these stages when used as the Source Stage will internally use the FastExport utility.
How different is the Teradata connector stage when compared to the above two since connector stage also uses FastExport internally. IBM suggests Connector stages to be the future. Does this mean EE and Multiload stages could be deprecated in future.
Thanks