Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2010
Added on Sep 30 2010
3 comments
372 views