The process of loading data into BICS has been well covered by other OBIEE bloggers like:
Mark Rittman: Introduction to Oracle BI Cloud Service : Provisioning Data
Kevin McGinley: Oracle BICS Day-In-The-Life (DITL)
The purpose of this post is to look "behind the scenes" into the metadata behind the Data Loader application in BICS.
Data Loader Background