DSXchange

...And only ONE link.

chulett wrote:Never seen any such thing. What 'update action' are you using? How many links are going into the stage?

It is a "Custom SQL Statement" like below -

INSERT INTO TABLEX (A, B, c) VALUES (SEQ.NEXTVAL,:1,:2)

Hi All, 8x SERVER STAGE - ORAOCI9 When inserting records into the taget oracle table (which is truncated) job throws warning messages of "unique constraint (UK) violated".But the data being inserted DO NOT have any Duplicates on UK. The reason this is happening is becuase of the execution ...

Kumar, it seems the Datasets were dropped and recreated.

Thanks all, great information. I could get that working fine using the Teradata EE.

Thanks all for your suggestions. I got that fixed. It was due to fault with internal datasets that datastage creates while extracting the source data from Teradata. Admin people took care of that. But this code may also come in some cases due to extra spaces in query.

Satish.

Hello All, I am trying to extract data from Teradata Enterprise Satge and i am getting the following error: info: Contents of phantom output file => RT_SC356/OshExecuter.sh [20]: 1404 Memory fault Fatal: Parallel job reports failure (code 139) Simple SQLs are running ok but SQLs with a subselect are...

I haven't seen that error before. However, have you tried using the Teradata Enterprise stage for retrieving data? That also uses FastExport for reads (FastLoad for writes). We have had much better luck using the Enterprise stage than any of the other API stages. Brad. Thanks Brad. Now i am using t...

Hello All,

I am getting the following error when using FastExport to extract data from a teradata table using MLaod stage.

**** 14:16:19 UTY8400 Error determining default character set name, code = 224

Does anybody have an idea what this error is about?

Thank you,
Satish.

Hello All,

I would like to know if we can have a reject link / generate reject file from XML output stage.
If it is possible, can you please let me know how this is accomplished.

Thanks,
Satish.

Hello All, We are trying to extract/ read huge data from Teradata in Datastage EE. We are trying to decide which stage is better, the Teradata Enterprise Stage or Teradata MultiLoad/FastExport stage. Can anybody have any idea of apprx. cut off records (Like < 1million reads use Teradata Enterprise a...