DSXchange

Char and Varchar will have different Hash Value and may fall in to different partition. PS : Although not all posters are from US, you hardly waited for an hour and decided to demand answer again. This is all volunteer site and people post when ever they have time and it will not make a difference i...

:shock: You can also have 70 links coming out of a single transformer if you need to implement 70 different type of hard coding and to be sent to 70 different XML files. I can't think of a scenario for these simple transformation which you cannot do in a single transformer. You may have to use neste...

depends on how you want it to behave. By default Null will not be matched to another null in different table. For the basic reason that two unknown cannot be the same, there are chances but cannot be guaranteed. However if you want to handle it explicitly, you can do that.

Well, there should be some more details for the error, can you paste the all error messages in it entirety? after masking IP, server details and credentials of course, if any.

What about other alternatives mentioned, did you read next 2 posts.

However I prefer to separate deletes with inserts and get it done as two separate steps.

one question, If you need to connect to oracle, why not use a oracle connector instead?

What happened when you ran that job on one node?

hash partition on CERTIFICATE_TEMPLATE_ID. This will ensure all the 50 records for CERTIFICATE_TEMPLATE_ID=449 in the same partition.

However it can only be guaranteed when all 50 records go as same transaction, so you may have to set the transaction size or basically the commit interval to 0.

viewtopic.php?t=153932

This post should give you little more detail on how to do it for files.

I second the thought of having single concatanated field for key. You can even have the key field location or start end position parameterized.

a little confused on what you are trying to achieve. A little explanation is required.

Thats a 7 year old post and I hope it was already resolved. However for the last poster, below are some details. When you give admin privilege you are not required to assign role to that user for a project. However you cannot give every one administrator privilege. If DataStage and QualityStage user...

http://db2commerce.com/2011/04/14/how-t ... -database/

Steps to catalog a db2 database.

Do you have a DB2 client installed on server 2 (engine)? I installed on Server 1 as repository is there in DB2 database created during installation. But did you install a client on Server 2 where engine resides?

on second thought ask DB2 admin if the listener goes down intermittently or if there are any connctivity issues between the servers or if you are hitting the connection limits.

Check if this helps

http://www-01.ibm.com/support/docview.w ... wg21675699