DOP and table comparison

[system]

Hi,

While performing delta load in Data Services, i have to join 5 tables (3 master and 2 transactional).

I am using Table comparison transform for getting the changes.

Its very slow. How can i use DOP with Table comparison transform?

---

suma_ys (BOB member since 2009-06-12)

[system]

You can use DOP with the Table Comparison transform if you use the Row-by-row select or cached comparison table methods.

There may be better ways of optimising this load though. Can you constrain the data which the delta load is being compared to?

---

finbo (BOB member since 2006-12-15)

[system]

I have the same issue

120×120 10.4 KB

Hi, I have a type 1 oracle target, and my DF looks like this Delta–>TC–>KeyGen–>MapOper–>Trgt. Now the problem is, in my target table we have 35Ms of records and in the delta 5k records daily. I have created the DF and in the test run, the jobs starts and never ends. I have tried all 3 options in TC, nothing worked, what would be the best option to select in TC to compare the target? Or am I doing in the wrong way? Thanks In Advance Praveen Reddy (BOB member since 2006-12-26)

got few replies… check…

---

Praveen Reddy (BOB member since 2006-12-26)