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!

ETL taking too much of table space that it crashes on running full load.

Yahya ZafarSep 24 2018 — edited Oct 2 2018

Hi All,

I have a fact table named viewership. It contains about 130 million records. I have written ETL such that first I import the data from the external database server to BI database server in a stage table, then I have created a mapping which puts the data into the actual fact table.

The problem that I am facing is that when i run the ETL for full load, it crashes as it consumes too much of TEMP table space. I am looking for a way through which I can solve this issue of some way through which I could write several mapping that load the data in smaller chunks.

Your help will be great.

Regards,

Farrukh Nasir Siddiqui

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2018

Added on Sep 24 2018

#business-intelligence-applications, #data-integrator, #mapping, #obiee, #odi, #oracle, #system-management-and-integration

3 comments

349 views