Can anyone help with loading data from Oracle to fact tables?


I am new to the TRIRIGA Real Estate Environmental Sustainability (TREES) module. We are planning to bring the data from another database to our metric table. Can anyone share the document which can help me to load the data from an Oracle Database to the fact BO? Thanks in advance.

TREES is expecting the sustainability data to be organized in the energy logs (carbon, emission, water, etc.) per building per month. You will probably want to use DataConnect (DC) to set up staging tables and via DC job insert and associate the data in the appropriate logs. Once the data is in the logs, the TREES ETL would build your fact tables. Calendar Period is a classification and has its own unique format that you need to map (that you can do via workflow). Energy Type is also a classification that will need to be mapped accordingly…

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s