DB_BLOCK_SIZE for Oracle
What should be value for DB_BLOCK_SIZE in Oracle DB (10g Rel 2). Oracle recommends 32 but if you google around a little bit, you will find 100's talking against 32 block

ETL from Oracle to SQL Server 2008 Data Warehouse
Hello, Our data warehouse runs on SQL 2008 servers. One of the transactions systems we have runs on an Oracle database and managed by a separate team. What are the recommended methods to extract source data from an Oracle database and loading to a

Join PTC sites using referral builder and get extra credit
Join one of the best referral building sites I have come across, there are additional options to earn credits as well, this will help you to build your own downline in return. Join now using the link

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)
Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Oracle fresher and Exp.Require at oomsystechnologies
Oracle fresher and Exp.Required Experience : 0-3 yrs Location : Chennai Education : BE., MCA., JobPosted Date: 31-01-2011 Company Profile :: We, Oomsys Technologies is a software development company in

Loading Future Dated Rows to Dimensions
Hi All, Our OLTP system supports effective dated concept. So users can enter Future Dated Rows also. And in our Warehouse we have both Type1 Dimesnions and Type2 Dimensions. When loading the data to Type1 dimesnions, if we load future dated row

Partitioning Strategy for Fact and Dims in Oracle/DB2/Sybase
Please specify the partition strategy you follow in your organization for facts and dims in Ora/Sybase/Db2 Thanks, bi_at_nj

BFL FUTURE
Lot of people will pay attention to EPS AND P/E However we can get many bull factors from quarterly reports and annual reports. Once we read quarterly reports we can become bullish, bearish or extremely bullish. We can become extremely bullish by

Pivoting data on the fly using Oracle 11g PIVOT clause
Hi All - I am hoping some folks here can give sound experience advise from those having working experience with Oracle PIVOT clause introduced in 11g. Below, I am describing a scenario to see if feasible to use PIVOT for these

Dimension Table Indexing Strategy
Please tell me what kind of indexes you are using in your dimension tables in your organization. I am looking for dimension tables indexing strategy for Sybase, Oracle and Db2. If you have any indexing strategy document for Dimension tables for

Converting Columns into Rows.
I have a requirement where I need to convert rows in columns. The data is quite huge there would be around 200 million records. The sample table contains only data for five months but in actual 12 months of data come in a single row and number of columns

Currency tax — a way to invest in our future
Currency tax — a way to invest in our future (Rep. Stark) By Rep. Pete Stark (D-Calif.) - 07/20/10 03:51 PM ET Each day, $4 trillion dollars of currency are traded. For international businesses and travelers, trading dollars for other currencies serve

Dynamic dimensions
What is the best way to handle dimensions that change depending on user parameters? For example, lets say you want "Months Since Inception" to be a dimension, because you want to bucket by it (i.e. 0 to 50 Months, 51 to 100 Months, etc.) but

Back to the Future remake staring...
JUSTIN BEIBER? http://www.examiner.com/tv-in-national/justin-bieber-to-star-back-to-the-future-remake That is it. Some one must nuke Hollywood RIGHT NOW! /wrist

Periodic snapshots - what is better?
Apologize in advance for a lengthy but general query – I hope there is an expert who has done this many times that can help me. We need to build a periodic snapshot table in our data warehouse. This is an example of a bank that needs to store account