Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sequence Numbers being used at a high rate

user120006Sep 30 2010 — edited Sep 30 2010

I am using OWB 11gr1 on a 11gr1 database.
I have a mapping to a table that has a loading type of INSERT/UPDATE ROW Based on Target

Even when only 4 records are being inserted, about 2000 sequence numbers are being used. Other dimension ID are not being changed but it seems that there is a high number of sequence numbers being burned with each insert.

Any Idea Why?
thanks
greG

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2010

Added on Sep 30 2010

#data-warehousing, #owb, #warehouse-builder

3 comments

373 views