Working of Link Ordering

dxk9 · Post by **dxk9** » Sun May 20, 2012 8:12 am

Hi,

I have a job which reads data from DB2.. Upserts them into DB2 (link 1) & update a flag in DB2(link 2).

How this works ?? Will the 1st record sent to Link 1 gets processed before its being sent to link 2 ??

Or the transformer link ordering doesn't have any impact on this & the records flow directly on link 1 & link 2. (both are main outputs & not rejects).

Regards,
dxk9

chulett · Post by **chulett** » Sun May 20, 2012 8:28 am

dxk9 wrote:Will the 1st record sent to Link 1 gets processed before its being sent to link 2 ??

This.

dxk9 · Post by **dxk9** » Sun May 20, 2012 8:31 pm

We don't have any delay in the processing of records in Link1 (insert else update) & Link2 (update). Especially don't want Link 2 to be faster than Link1.

But since the logic of both the links are different, we thought it might be an issue.

So since you say that Link1 processes first before the record goes to Link2, we can go ahead with the design right ?

Thanks,
dxk9

dxk9 · Post by **dxk9** » Sun May 20, 2012 8:32 pm

To add on.. The array size & Transaction size of both are (1,200).

Thanks,
dxk9

chulett · Post by **chulett** » Sun May 20, 2012 8:40 pm

It really is as simple as the links are completely processed in order, so the first one must go to the target and its fate determined before the second one is... released.

Now, array and transaction sizes can complicate error reporting and may affect how it works depending on the relationship between the two links. If the second link depends on seeing the result of the first link then you may need to drop one or both of the sizes down to 1 or at least ensure both links are sent to the same (single) target stage so their work is done in the same 'transaction'.

dxk9 · Post by **dxk9** » Sun May 20, 2012 8:58 pm

Thanks Craig !!

But I got only your 1st statement, wasn't able to read the rest of them as its a 'premium content'

Thanks,
dxk9

chulett · Post by **chulett** » Sun May 20, 2012 9:29 pm

As Ray would say, the issue of Premium Content is easily solved.

dxk9 · Post by **dxk9** » Sun May 20, 2012 9:33 pm

Its not free.. so its not easy

ray.wurlod · Post by **ray.wurlod** » Mon May 21, 2012 2:25 am

Without it, DSXchange would cease to exist.

Premium memberships are used to fund the hosting and bandwidth charges incurred by DSXchange. Notice the absence of ads? Notice the good signal to noise ratio?

dxk9 · Post by **dxk9** » Mon May 21, 2012 3:18 am

Very true Ray.. !! I agree to ur point..

eostic · Post by **eostic** » Mon May 21, 2012 6:39 am

also check interprocess row buffering...that will dramatically impact the normal default "process each link thru completion" behavior.

Ernie

chulett · Post by **chulett** » Mon May 21, 2012 6:42 am

Thanks Ernie... I had made a mental note to mention that as well and then managed to forget it mid-post, it would seem.

rameshrr3 · Post by **rameshrr3** » Mon May 21, 2012 10:58 am

I guess a company can apply for a group membership ? Or is that feature not available yet ? After all no biz says no to 'help' that leads to profit$

ray.wurlod · Post by **ray.wurlod** » Mon May 21, 2012 5:02 pm

Corporate discounts are available, but the model is for multiple individual memberships from that company's email domain. From memory the discounts kick in at five users.

But even without the discount it's less than 30c (Rs12) per day. A week on DSXchange costs less than a cup of coffee!

dxk9 · Post by **dxk9** » Tue May 22, 2012 4:36 am

How to check on the 'interprocess row buffering' and what kind of impact does it hold on the behaviour..

I read through this, but since I couldn't test it to really understand the flow, felt your thoughts might be more helpful in understanding the concept.

Thanks,
dxk9

Working of Link Ordering

Working of Link Ordering

Re: Working of Link Ordering