Using Hyperion Data Interface Tables as Sources

Interface tables enable you to bring information into the Hyperion schema through database operations (SQL loads or leveraging Hyperion data integration products). After information is stored in interface tables, the standard mapping and load mechanisms provided within data synchronization can be used to bring the information into the respective Hyperion product. Interface tables are useful in situations where you do not want to pre-format text files for flat file loads and want the power and flexibility of a relational database for staging information into the Hyperion product suite. The following sections provide additional detail on using data interface tables as sources: