http://biexplorer.com Wed, 24 Sep 2008 06:37:20 +0000 http://backend.userland.com/rss092 en I am thinking of moving back to biexplorer.wordpress.com and giving up biexplorer.com. This is because I am nearing renewal soon and am wondering if it makes sense to have your own domain or not. Will keep you updated. But please bookmark http://biexplorer.wordpress.com too. http://biexplorer.com/contemplating-a-move-to-wordpress-domain/ In this article, let us see what a staging area is, its types and the reason to have one in your data warehouse. Ok, what is a stage area? It is that part of a data warehouse where data is stored physically on disks or files (or whatever)... but as an intermediate ... http://biexplorer.com/stage-area/ Estimation of ETL effort is not always fun. (as with any estimation). There are several ways of estimating the effort needed to complete an ETL job. Work Breakdown Structure (WBS) is popular. And so is Function Point Analysis (FPA). But the most widely used is the one that factors in complexity based ... http://biexplorer.com/etl-effort-estimation-points-to-factor-in/ Please read this article. Recently, SAP - BOBJ migrated its BOBJ customer support platform to SAP. The result was a disaster. Several customers didn’t have access to the support site. Read more on this at the link given above. Also have a look at this link at BOBJ support site where users are ... http://biexplorer.com/bobj-customers-angry-after-migration-of-support-to-sap-system/ Please read the article at this link. What do you think? Is open source database a viable solution? The link says (as quoted by Forrester) that the market share for Open source database is at $850 million Commercial databases is $ 16 billion Key take aways from this article: Many vendors are now open to the ... http://biexplorer.com/is-open-source-database-a-viable-solution/ Here is a good link on Explain plans and on displaying them. http://optimizermagic.blogspot.com/2008/02/displaying-and-reading-execution-plans.html http://biexplorer.com/displaying-reading-execution-plans/ I was reading this today and thought it was interesting. Karen explains why having min and max in the same query impact performance and how to tackle the same. http://biexplorer.com/min-and-max-in-same-query/ Recently I was working with a few DB2 UDB 9.5 tables and discovered that decfloat datatype columns were not recognized even if I had checked the option to recognize unsupported datatypes as varchar. I mailed someone who interacts closely with the product group in SAP - Business Objects. As of today, BOBJ ... http://biexplorer.com/bodi-bods-do-not-support-decfloat-datatype-in-db2/ Here is a query that you can run on the BODI repository to fetch the job schedule details. Select upper (al_lang.NAME) as jobname, upper (al_sched_info.sched_name) as schedule_name, al_sched_info.start_time as start_time, al_sched_info.host_name host_server from di_edw.al_lang al_lang full outer join di_edw.al_sched_info al_sched_info on al_lang.guid = ... http://biexplorer.com/get-bodi-job-schedule-info-from-repository/ Here is a good article on tuning DB2 databases. And here is another that might help you. http://biexplorer.com/db2-performance-tuning/