How to Create Data warehouse Test Environment using Oracle, IBM DataStage & IBM Cognos OR Microsoft BI Stack
Posted on 2013-12-05
For some of you it might be a silly questions but I'd like to create, test & Reporting data warehouse environment(Database, ETL, Reporting) for learning purpose on my laptop, laptop is enough memory (8gb) to handle basic the Oracle Virtual machine environment, I've build Oracle 11g2 VM machine with IBM Cognos 8.4.1 on WinXP. Now I would like to know from here where I can start. OR Should I follow the Microsoft BI Stack? I just want to get my hands dirty with practically learn technologies in data warehousing, ETLs and Reporting.
I've skills in Oracle 10g2, 11g2, IBM Cognos (Report Studio, Framework manager, Transformer). Please advise/share your experience for my learning curve. It would be greatly appreciated.