#multiload

[33libras]

[sevenpips]

Improve your Teradata Load Performance

Improve your Teradata Load Performance

Teradata allows only a limited number of bulk loads to be executed simultaneously as they consume a lot of resources.  The concrete limit depends on your Teradata system. It will be somewhere in the lower 2-digit area.

Whenever the utility limit is reached, additional requests will end up in a workload queue. On a heavily loaded system, this will lead to a unstable load behavior: Run times for…

View On WordPress

[kirbits-blog]

MultiLoad Teradata

Cargar archivo plano con registros repetidos en Teradata MultiLoad

.LOGTABLE COMPRAR_MEJOR_QC.auxLog ; .LOGON 172.18.149.195/consulta,consulta;   .BEGIN IMPORT MLOAD TABLES  COMPRAR_MEJOR_QC.CHI_STOCK_AUX; .layout custlayout;  .field dia *  VARCHAR(250);  .field Id_Material  * VARCHAR(250);  .field Desc_Material   * VARCHAR(250);  .field Id_Proveedor  * VARCHAR(250);  .field Proveedor  * VARCHAR(250);  .field Stock_Valor_CPP * VARCHAR(250);  .field Stock_UMB * VARCHAR(250);

.DML LABEL custdml; INSERT INTO COMPRAR_MEJOR_QC.CHI_STOCK_AUX  (dia  ,Id_Material  ,Desc_Material  ,Id_Proveedor  ,Proveedor  ,Stock_Valor_CPP  ,Stock_UMB) VALUES  (:dia  ,:Id_Material  ,:Desc_Material  ,:Id_Proveedor  ,:Proveedor  ,:Stock_Valor_CPP  ,:Stock_UMB);   .import infile D:\mload\N645.csv format VARtext ';' layout custlayout apply custdml;   .end mload; .logoff;