Partitioning Strategy for Fact and Dims in Oracle/DB2/Sybase

Fact Table Indexing Strategy

Please explain the indexing strategy which is in use in your organisation for fact tables in your current database(oracle, sybase, db2) Specify volume as the indexing strategy may be based upon the volume of data. Is there a well laid out strategy

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

Partitioning Large MS SQL-Server FACT table

Scenario: Data should be retained for 5 years or 60 months. Table will have about 800 million records Have adapted monthly partition. Each File group have 8 files to match the Number of CPU improve parallelism. Each partition will be kept i

Partition Pruning issue

We're looking into partitioning one of our star schema fact tables on Campus Name. The fact table consists of students enrolled by Campus. We're using Oracle 11g. The DBA is saying that we need to add Campus Name to the fact table in order for partitio

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

Sybase Indexes

Is yours a Sybase shop? Please specify what kind of indexing strategy you follow in your sybase databse for bi / dw applications . What kind of indexes do u use in your warehouse / bi applications in Sybase shop? Do you follow any indexing strategy i

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

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

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

Walkins For Analyst In Oracle India Private Limited

Experience:0 Years Job Title: Analyst Location: Bangalore Education:UG – B.A – Any Specialization,B.B.A – Management,B.Com – Commerce,B.Sc – Any Specialization,BCA – Computers,BHM – Hotel Management,PG – M.A – Any Specialization,M.Com –

Dimension with two hierarchies

I need to design a dimension with two hierarchies 1. Location -> Building -> Room -> Cabin 2. Location ->Building I need the hierarchy 1 to be referenced in one FACT table and hierarchy 2 in other FACT. But my ETL tool allows only the dimension ke

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

What to do when the weighting factor of a bridge table no longer seems relevant?

I have a fact table that has healthcare claims data. Since a given claim can have multiple diagnoses, I'll use a bridge table that links a bridgekey from the fact table to the bridge table. The bridge table will also have a diagnosiskey that ultimately