DSXchange

What does this mean? :? but it wont generate sequence number as I am on 2 node structure. Lets say If I give 1000 in the block, each node will be reserving the 1000 numbers at a time and if 1st node starts from 1,2,3... and the second node will starts from 1001,1002,1003... and so on. Please correc...

Thanks Ray , and Yes I can use the big number, but it wont generate sequence number as I am on 2 node structure.

Any more settings can be done to get it perform well ?

Hi All, I have a job running for 28 minutes. Just wanted to check if some one can help me in tuning my job. Job design looks like this : Dataset - Lkp(with DB2) - Xfm - DB2 This job was taking less than a minute , after I had included the Surrogate key in the Transformer this takes 28 minutes. Surro...

Use a server job in which you can interpose a blocking operation (these are banned in parallel jobs). Otherwise there are no guarantees - among other things it depends on the level at which you are locking, the number of rows per transaction and the array size. Thanks Ray, Will this imply to the fo...

Thank you Ray,
What if I wanted to go by option 1 and overcome the locking problem what would be the workarround I need to takecare of ? can you please let me know. Thanks.
Rajan

Done , thank you

Hi all , I will have to do a Lookup ,Insert and update all on same table Irrespective of volume size ( Actually volume is 50k records), what will be the best design approach can we follow. 1) Can we do Lookup , Update , Insert all on one table and in one job ? If so what will be the pre steps we nee...

Hi Ray, Could you please help in sharing some information ? I have the similar senario now, I will have to do a Lookup ,Insert and update all on same table Irrespective of volume size ( Actually volume is 50k records), what will be the best design approach can we follow. 1) Can we do Lookup , Update...

Hi Rajan, Assuming you can afford to disable NLS for this particular stage I have come up with a temporary workaround until the root cause is identified. In the DB2 API stage under the NLS Map tab rather than selecting from the list simply type 'OFF'. Fortunately for this particular project NLS was...

I am in the same issue now, Job is very simple Its a DB2 UDB stage to a Sequential file. 1) Fetching only one field and its an Integer( Tried changing to Char also) 2) Volume is 325944 ( Tried fetching first 10 rows also) 3) having this error with only one table. I have plenty of other jobs working...

Is there anyone know the root cause about the below issue? This issue happened for Information Server v8.1 on Red Hat Linux 4. Sequential file -----------------------> DB2_UDB_API The job is very simple. But when DB2 API Stage was used and the target table name was like SDS7.SDS_I_143_RAW_MATERIAL,...

Hi Eostic, Yes we are looking for IBM tools which helps in convertion of Table definition ,I am tried seaching in the forum and web on IBM tools I did not find any relevant to that. By chance if you remember can you please name it. regarding "Reverse Engineering" Chulett has cleared me. Th...

Hi All We are in process of converting Informatica to Datastage jobs. All I have a question is can we import the Informatica Table Definition into Datastage ? I tried exporting the Informatica Source Object in XML format and then converted to .xls and then took the Column names ... there is much man...

Thank you , All I did is created again the standardise files and frequency files for both source and ref data. then i configured the match specification again with only Name and blocking with city ( source and ref). Job ran fine :) Thanks emeri1md once again. I wouldn't recommend matching on only th...

Thank you so much for your time, still that was a learning stuff. Can you please give the process of performing the following task ? at least meight help me wether am on the path.... I have 2 source one form database and other form a file. the names are organizations name , other are some address fi...