DSXchange

@Pandeesh
I am also trying to find the same thing, but no success till now.
Even my job is not complex too. A simple one-one mapping and finally writing in upsert mode.
But I am getting different counts in target.

@Ray, Yes I am having more updates than my inserts. Thats why I chose Update then Insert mode. But the issue is in both modes I get different no. of records in my target table. Performance is not an issue because in either mode my job finishes in a minute. That's why my friend suggested to limit Rec...

Hi, Plz answer my queries (though they are sillY :D ) 1. DB2 Connector is my target stage, so whats the difference between "Insert then Update" and "Update then Insert" mode? performance wise, logic wise etc. 2. One of my friend told me to keep "Record Count" = 1(i.e. c...

What is the size of the scratch disk?

could u tell me the highly recommended variables.? in administrative client if i give incorrect values for all the environmental variables and running the job..? will the parallel job run..? hope it wont.. in order to run the parallel jobs some sort of variables are needed right.. those variables sh...

hi..

what are all the mandatory environmental variables to run the parallel job..?

could you list down all the variables..

Try this One- Sort those 372 records based upon your key column and input them into a tranformer. Use stage variables there to find the duplicate record and take it to another output.

@srini and fmou
You are making me confused

@Ray
You mean to say that first left outer join will happen on T1 and T2, then result of this join will be left outer joined with T3 and so on??

@Ray,
Will check and see how my performance is.

@PaulVL
We also have some tables which have avg. row length > 2.5 MB

HI, I have a small query. If I am having 10 Src table(T1,T2...T10) and I am using a Join stage after the Src, keeping left outer join as join type. Then what will be my output like? Like the remaining 9 tables(T2,T3...T10) will make a inner join and then a left outer join will happen on T1? Or Will ...

@Ray The avg. row length of my table is 985KB (kilobytes). So according to your formula it comes out to be less than 1 :!: @PaulVL No, my question was for ODBC Enterprise only. On second thoughts what if I keep more rows in the buffer than the default that is defined in a stage ? Will my job abort o...

Ok,
But we are still trying to find the root cause.
No success yet

@SURA

Lolz.

I am also having the same issue.
Help needed.

Thanx Ray,

Can you explain what is an "network packet size"?
and how to calculate it?