Good link for Oracle DBA related tips

Cloudera - Hadoop for enterprise

this is competition to EMC's Greenplum and is a startup. I like the passion of this company.

https://ccp.cloudera.com/display/SUPPORT/Downloads

They also created "sqoop" which allows Oracle/MySQL data to be pushed easily into HDFS.

http://www.cloudera.com/downloads/sqoop/

Generating OBIEE Catalog Report

OBIEE allows to query the webcatalog via a webservice:

http://gerardnico.com/wiki/dat/obiee/web_service

http://tipsonobiee.blogspot.com/2009/07/obiee-web-services-using-net-and-c.html

http://oraclebizint.wordpress.com/2007/07/31/customizing-obi-ee-soap-api/

Generating OBIEE RPD Report

This is pretty useful for a knowledge transfer. Click on tools -> utilities and then select "Repository Report"

Hadoop getting started

Time Dimension Build up in OBIEE

http://www.oraclenerd.com/2010/03/obiee-report-drilldown.html

Datawarehouse Interview Quesitons

• http://www.geekinterview.com/Interview-Questions/Data-Warehouse
• http://www.phlonx.com/resources/nf3/  --> Normalization process
• Top N query in Oracle:  http://www.oracle-base.com/articles/misc/RankDenseRankFirstLastAnalyticFunctions.php