DSXchange

Hi, Could any one help in generating a surrogate key value which should take the Initial value as 1 and increment by 1. i.e, My data should like as this: 1 2 3 4.........so on. I have bulit a simple job which has 2 stages .......A surrogatorkeygen and a target sequential file. Following are the Valu...

Hi Arnd I am Not sure of exact bytes per row,But that Particulat input table has so many columns to Extract compared to other tables. So,Is it that the no.of columns that are getting extracted have the Impact in terms of Processing speed? Is there any way improve the Performance for the scenarios li...

Hi All, I have loaded the Data into the Target Sequentil File.But when I am trying to Read the Same its giving the Below Error. ##E IIS-DSEE-TFOR-00089 13:01:15(704) <_ABORT_IDENT_,0> The runLocally() of the operator failed. ##E IIS-DSEE-TFOR-00089 13:01:15(706) <APT_CombinedOperatorController,0> T...

They are DB2 tables.

Could you please let me know how to check bytes/sec insted if rows/sec

Hi All, I have a Job which Involved a Join Stage and 5 Source Tables and a Target table.(DB2) My Problem is While extraction of Data From these 5 Tables the data is getting at extracted at differetnt rates(No.of rows extracted per second) evaen though the settings for the 5 source table stages are ...

Hi All, I have modified an existing Job in the sense that Jst modified the customized sql which is used to extract the data.And when I tried to compile it and run the Job I am getting the following error. : Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009 DSTAGE...