DSXchange

Has anyone encounter this error with the *.o file? We are trying to migrate executables to another environment (another server) by exporting the ETLs but had this error:- Error: Export of job executable 'TWN_getFullChannelSKey' was incomplete. Failed to export compiled job object 'V0S12_TWN_getFullC...

I have to update an Oracle reserve word (USER field) in the Oracle Stage. In Oracle, to update the USER field, it is just to append the double quotes. Eg. UPDATE TABLE_A SET "USER" = ORCHESTRATE."USER". But when I insert the statement that way in the Oracle stage, it gives me an ...

Thanks for you help, however, I would appreciate if you can elaborate more on what you mean by process limit. Is this process referring to the Operating System process (in our case, AIX) or is this some parameter that needs to be changed/set in Datastage. Thanks for your help again.

Hi, I have executed a job and encountered this error. Hope you guys out there can help me out. I have no idea what it is talking about. Someone help!! main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel APT_DBExportOperator in ora_F_P1...

I have tried searching throughout this forum on Surrogate Keys but difficult to find something on DataStage EE. Would just want to hear from all of yr experiences in generating Surrogate Keys. Here are the alternatives I have identified in populating Surrogate Keys:- 1. Using the Surrogate Key Gener...