topic Update only Selected Column using tpostgresqlOut in Talend Studio

Update only Selected Column using tpostgresqlOut

_AnonymousUser — Wed, 12 Aug 2015 11:49:04 GMT

Hello,
I am migrating data from mysql to postgresql database. I have 600 columns in mysql table A.I want to move these values to postgresql table A.Due to the java limit of a method can have at max 65535 bytes its giving error if i do this task in one job ,So I have split the job into two subjobs. First job inserts or updates first 300 columns and Second job updates next 300 columns. But its not working as expected. Its able to insert or update first 300 columns but when the second job finishes its going to overwrite the first 300 column as null.
Is it not possible to update only selected column out of this 600 columns in talend?

Re: Update only Selected Column using tpostgresqlOut

Anonymous — Wed, 12 Aug 2015 12:53:43 GMT

Please Insert option instead of "Insert or update" for action on data.
Please check "parallel execution" and give value 2 and try once.

Re: Update only Selected Column using tpostgresqlOut

_AnonymousUser — Wed, 12 Aug 2015 13:34:11 GMT

I want both insert and update because in my mysql table, table will be updating frequently and that needs to be migrated to postgresql table.
In my parent job I am using two tRunJob components. On completion of first tRunJob (i.e. after the first 300 columns are insert/updated in child job) second tRunJob will start(this is to insert or update next 300 columns).
What is this parallel execution? in which component this will be available. I am new to this talend. Kindly help