DSXchange

Are you using TENACITY? If not, an process that can not get a Teradata session will abort. It may be this that you are seeing, and would explain the apparent randomness of the behaviour - sometimes ... Thanks Arndw,ray, Arndw, I have tried writing to Peek stage with 1 node configuration file and th...

The issue would be that the data which ur trying to load does not match with what the teradata table defn. , U might have some kind of conversion happening - U need to check if trying to insert a different datatype to what is has been defined, is so the u could use CAST function. Hi All, Yes i am u...

...Does this mean that metadata is changing for records between 148 to 200 ?... Probably. If you change your job to run on 1 node or in sequential mode, and output to a peek stage instead of to Teradata you should find the row that is causing your problems. Hi ArndW, The Job ran Succesfully once fo...

saur_classic, although you stated that "the Metadata for both files is the same", the error message from DataStage is ...column descriptor count does not match field count... So there is a difference between the format of the two files. Dear keshav0307,ArndW I have Manually checked the Me...

Hi, I am having a very tough time with Datastage. A Datastage job is made to load from Flat file to a teradata table. The Job runs fine for a todays file and then i recomplie it and try to run the same job with yesterdays file but the job fails. The Metadata for both the files is same. the job have ...

Hi,

I am facing difficulties in extract the last portion from the URL string
for e.g.
Source sends "root^xhtmlmp^samsung(xhtml)^samsungsgh-a701" and we need "samsungsgh-a701" from it.

Does Datastage provides any Function to do the above job?

Saur

Hi, I am facing problem in Converting String to Timestamp. The Job inserts into Teradata table which has a Date Column as Cre_Dt TIMESTAMP(0) FORMAT 'YYYY-MM-DD HH:MI:SS' and the Source file sends the Data in Format 'Mon Jan 08 00:00:00 EST 2007' . In the transformer just before insertion into the t...

Hi, I am working on Datastage 7.5 Release and the Underlying OS is LINUX SUSE. I am trying to insert a table X with some rows using Teradata Enterprise Stage. Table X has Primary Index and one Secondary Index defined on it. While running the Job I am getting the below error. NUN009_X: Table X has se...

Hi, I am working on Datastage 7.5 Release and the Underlying OS is LINUX SUSE. All PX Jobs are Failing due to Broken pipe Error. The Job contains 2-Dataset stage,1 Change Capture and 1 sequential file. The Exact ERROR is Fatal Prev_Snapshot_tbl_Ds,0: /bin/echo: write error: Broken pipe Fatal Prev_Sn...