Hi,
I am trying to load to Teradata using TD Connector Stage.
Job Design
DataSet----Transformer----TD Connector(Access Method - Bulk and Load type - Load)
Job is failing with error
Error tables are invalid OR <tablename> is in an invalid state for Load
Main table is one database and error and log tables are in different database.
No locks on Main table,
Thanks in Advance
Teradata Connector load using Bulk mode
Moderators: chulett, rschirm, roy
Re: Teradata Connector load using Bulk mode
This concerns me. If they are truly in "different databases", wouldn't they require different connection details? I'm sure the stage is only asking for one. Is this even supported outside of DataStage?swadeep wrote:Main table is one database and error and log tables are in different database.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
On teradata the term database is a bit more like a schema in DB2 / Oracle - i.e same physical database instance - but in a different location within that database.
This is a bad analogy but havent much time - however when querying a table you would type
select * from <database>.<tablename> - and it is the first bit that could be the issue, if omitted it defaults to the 'database' specified in the connector stage
am not on datastage at mo - but maybe worth checking how you have specified the Error table and Log Table names in the connector stage (i.e. have you used the <database>.<errortable> notation - and is it differnet to the main table notation
This is a bad analogy but havent much time - however when querying a table you would type
select * from <database>.<tablename> - and it is the first bit that could be the issue, if omitted it defaults to the 'database' specified in the connector stage
am not on datastage at mo - but maybe worth checking how you have specified the Error table and Log Table names in the connector stage (i.e. have you used the <database>.<errortable> notation - and is it differnet to the main table notation
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: