Which of these three different software’s extract, transfer and load data (Terabyte data) the quickest? This data resides in Oracle.
1 ESSBASE - Hyperion
3 SQL - TOAD
Currently, using MS Access queries have proven very sluggish and slow, and we are wondering if SQL in Toad might be a potential solution.
What are your thoughts regarding whether or not ESSBASE, Informatica or creating Hyperion cubes would be an option of being faster with ETL?