DSXchange

Hi All, Issue Category: Metadata Workbench As part of Automantion binding process ,its mandatory to import DataStage environmental variables to Metadata repository using ProcessEnvVariables.sh (scripts installed in the ASBNode/bin directory) While triggereing below script (ProcessEnvVariables.sh -di...

Hi, I gave like this; In Job Parameters Section : $APT_RDBMS_COMMIT_ROWS = 0 IN db2 Connector Stage --> Properties Tab --> Under Transaction Section : Record Count = 0; My data set is having 225 records, on table unique index is defined. Now after processing 102 records, the job aborted due to dupli...

Hi QT_KY: Yes, the connection was successfull, even I am able to run other jobs which were loading data into tables. We dont have any issues with Db2 Connector. But what I am looking is, if job aborts due to any Unique index constraint, then, it should not commite the rows which it processed. But as...

Thanks, Ray.

But the first error messages occured when I am using the Db2 Enterprise Stage. But the db2 data base is not partitioined in our Env , so we cannot use the Db2 Enterprise Stage.
So I am using Db2 Connector Stage now.

Tried with DB2 connector,
by giving $APT_RDBMS_COMMIT_ROWS = -1 or 0;
Record Count = 0;

But its not working.

Hi All, For one of the requirement, we need to create reports on Metadata Workbench tool (Data Lineage reports). We are facing some issues while performing Automated binding of stages with stage. We are using IBM Metadata Workbench v 8.1, Once after performing the stage binding in manual binding pro...

Thanks a lot!!
That worked for me.

Need one more help!!
Not able to perform stage to stage binding during automated services run for multi-instance jobs.

As file property in the job is having parameters.
Do we need to add that parameter at project level?

Hi All, For one of the requirement, we need to create reports on Metadata Workbench tool (Data Lineage reports). We are facing some issues while performing Automated binding of stages with the database tables. We tried below mentioned items: - Imported the tables in IA. - Ran automated process in me...

Hi All,

Can we find whether the field is having Negative(-) value then I need to write default value zero(0).

Please advise any easy way for this.

Thanks in Advance

The date format seems correct.

I am trying to pass the values to the parameters via a script that is called from within the main job run script. If this is not the way we can assign values to parameter set, how else can we do it?

We have a simple parallet job Src File --> Transformer --> Oracle Table First we had all the parameters deifned in the job and all the values are passed at runtime via a unix script and it all works fine. Now we added a Parameter Set to this job instead of defining the parameters in it and am trying...

Set APT_DUMP_SCORE environment variable to TRUE and go through the score in the job log.

Hi Sura, I tried that also but its not working in my case. Here source is orace table, souce column data type is varchar 20 nullable yes.but table contain only date part( like 2011-04-20) . the target table has date(timestamp format) and nullable no. still i am getting the same error in transformer ...

Hi All The job was running fine in 7.5.1A. Now we are migrating the project to 8.5. so our jobs are getting the below warnings. "Conversion error calling conversion routine timestamp_from_ustring data may have been lost" My source is database Oracle and we doing conversion in the transform...

Thanks Andy, this helps.