Teradata Connector For Multistream
Posted: Fri Sep 05, 2008 8:54 am
I am trying to insert/update into same table using different stream using Teradata connector stage. Ristriction is i can't redesign the job i need to use multistream using Teradata connector
----------------------------------------------------------------
Teradata Connector
1) Multi stream one doing insert other update
2) Same table operation
3) Different Error/Log and work table names
4) error RDMS Code 2574 : Table being MLOADED
---------------------------------------------------------------
MLOAD Stage
1) Multi stream one doing insert other update
2) Same table operation
3) Different Error/Log and work table names also differnt report/contorl file
4) runs sucessfully
------------------------------------------------------------------
Do anyone know how to make it work.
----------------------------------------------------------------
Teradata Connector
1) Multi stream one doing insert other update
2) Same table operation
3) Different Error/Log and work table names
4) error RDMS Code 2574 : Table being MLOADED
---------------------------------------------------------------
MLOAD Stage
1) Multi stream one doing insert other update
2) Same table operation
3) Different Error/Log and work table names also differnt report/contorl file
4) runs sucessfully
------------------------------------------------------------------
Do anyone know how to make it work.