DSXchange

The issue was with IsValid function. Ran to success after making below change Before: IF IsValid(Source, "%mmmm %dd, %yyyy") THEN StringToDate(Source,"%mmmm %dd, %yyyy") ELSE SetNull() After: IF IsValid("date",Source, "%mmmm %dd, %yyyy") THEN StringToDate(Sour...

Hi, I need to convert incoming String to Date. The format of the string is "Month dd, yyyy" Ex: (November 29, 2012). I used below function and job got aborted with error " Invalid type: November 29, 2012." StringToDate(Input Column,"%mmmm %dd, %yyyy"). Please help on th...

Hi, I need to extract data from a source file. Format of the file is as below COLUMN - A|B|C|D|E ROW1 - 45|56|67|23A|| ROW2 - 45|56|67|23A|| ROW3 - 45|56|67|23A|Sam ROW4 - 45|56|67|23A|Martin ROW5 - 45|56|67|23A|Sunny ROW6 - 45|56|67|23A|Keaubu I'm using Sequential file stage to extract the data and...

Thank you Ray!

Hi, I'm using an Oracle query where one of columns in Where condition has '#' in value. The query runs fine in Toad or SQL Developer but is failing in the Oracle Connector. Please help. Original Query: ************* SELECT * FROM TABLE_A WHERE COLUMN_A = 'AB CDE #' AND STG_ETL_BATCH_ID = 1 Query in ...

Hi, I'm using SCD stage for Type 1 Dimension. As part of daily load, we have inserts and updates to the Target Table. Please help on how to identify the inserts and updates from the Output of SCD stage. For Type2 dimensions, we can identify based on Change Indicator but for Type 1, i'm unable to fin...

Thanks for the reply.

Job is running on one Node.

We could figure out the issue.
It's because of Nulls coming in one of the Key field. Teradata is unable to compare the Nulls. Replaced Nulls with a dummy character and was able to continuw with the load.

Hi, We are extracting data from a Flat file and loading to Table A. In the After Sql, we wrote a Merge query to Upsert data into Table B (which is a archive of Table A). Insert statement for Table A is running fine where as the Merge query for Table B is failing with error.."RDBMS code 2802: Du...

Thanks.
Implemented the same and deployed the code to Production.

Hope it don't abort again..

Since i have very less data, ran the job on One node and this might work for me.

Craig, Any suggestion on above?

I was also thinking to do the same (that wll work).
I'm dealing with 1.5Million data, so shouldn't be a problem for now.

Thanks Srinivas.

No other user or process is using the table.

Job is running on Two nodes.

I did hash partitioning on Primary Key on the input link of Oracle Connector Stage and updated Record Count to 2000.

Still the Job fails:(

Hi, My Datastage job loads data to Oracle table with below properties Write Mode: Update then Insert Table Action : Append Record Count : 100000 Array Size: 2000 Today the job failed (Update Query failed) with Deadlock issue "The OCI function OCIStmtExecute returned status 1. Error code: 60, Er...

Got the error.
It's issue with my Update statement. There was a typo error in one of the columns name.