Analytics 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!

Insert flow into I$ table is FAST, but Merge Rows is SLOW

kovarFeb 5 2018 — edited Feb 7 2018

Hi,

I have a really simple mapping with source table (2.4 million rows), 6 joined tables on it (most of tables have less than 10 rows, max number is 200 rows) and a Expression component where I have to perform TO_NCHAR for about 30 columns.

The target table is empty right now. I did a duplicate of IKM Oracle Incremental Update (MERGE) and did a small change on one step (so I can use it for my SCD1 needs), rename it to IKM Oracle SCD1 (MERGE) and this new IKM is used in this mapping. While Insert flow into I$ table is FAST, the Merge Rows step is extremely SLOW.

What could be the cause of this problem?

- Kovar

This post has been answered by kovar on Feb 6 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2018

Added on Feb 5 2018

#business-intelligence-applications, #data-integrator, #insert, #system-management-and-integration

4 comments

835 views