DSXchange

Hi You need to find out if the problem is really due to your database. First thing to do would be to swap out the database stage that performs the writes to writing out to a dataset (or even a sequential file). If the job performs well writing to files or datasets then you have a database performanc...

I have a need to pull data from a MS SQL Server 2005 database and create/populate tables in a MS Access database. I know that I will be using the ODBC method for accessing the SQL Server data...but what/how can I setup access to the MS Access database as a target. Any help/examples would be GREAT! ...

I have a need to pull data from a MS SQL Server 2005 database and create/populate tables in a MS Access database. I know that I will be using the ODBC method for accessing the SQL Server data...but what/how can I setup access to the MS Access database as a target. Any help/examples would be GREAT! ...

Hi, PDF files are usually hard to extract but it is possible. There are software (not Datastage though) that you can use to read PDF and then convert into Excel or CSV files. One that comes to mind is called Able2Extract. Just Google it. Once it's in CSV format then you can use Datastage to process ...

We have just started working with MQ. Of interest is the mqread stage.The stage expects a Work Queue but when we use a regular QLOCAL queue the job will fail to open the work queue MQRead_157,0: Connected to queue manager MQDX1011 MQRead_157,0: opened source queue IIS.WORK.QUEUE MQRead_157,0: workQu...

You can ignore the warning if you know what you are doing because DB2 is warning you that you are deleting ALL records from your table using the SQL statement. Is that what you want to do?

Try googling for ora-12571.

Ray's advice is good unless YOU happen to be the DBA.

I know that teradata utilities foundation needs to be installed on datastge servers. Do we need to install odbc drivers for teradata to access using odbc stage? What needs to be done to access new teradata db using odbc stage? Typically you are better off using the Teradata Enterprise stage rather ...

Have you done a search on "input buffer overrrun"?
This is a common problem and has been discussed before.

The Teradata Enterprise stage is installed when you install Datastage, so you don't need any checklist. Just do your typical install.

Have you tried the Teradata website?
In terms of h/w and s/w, that depends on what you need it for. Your question is too general.

Can you put your UPDATE as a After Job subroutine that runs after your load (sqlldr) finished? But you may need to be able to build the SQL script to do the UPDATE. Not recommended but I believe it's possible.

Is yor SQL Plus test being run from the server?
The error you're getting is an Oracle error and is quite a generic error in that it could be anything that causes it. Something must have changed in your server/network environment. Find that and you'll find the answer.

do you have RI (referential integrity) enabled in the table you are loading? FKs are notorious in slowing down any loads.
If there is you might have to drop all the FKs , do a direct load (check your SQL Loader ref) and once it's loaded re-enable your FKs.

you need to specify what errors you're getting. In terms of the output do you get the correct results? the warning message just means that your deduping on less keys than what you were sorting on which in some cases is legit. but if you are getting incorrect results then it's most likely to do with ...