DB_BLOCK_SIZE for Oracle

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

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

Oracle Warehouse Builder - what does the future hold?

I have a client implementing an analytic solution which uses OWB for ETL. I have concerns over OWB's future given the Sunopsis acquisition which they now call ODI (I think). Part of the appeal of OWB is it's low cost, I'm assuming that advantage will

Aggregate Navigator

Does anyone know of any current Aggregate Navigator middleware products?

Best method to track deleted records on source in Oracle

We need a way to track deleted records from the source tables in Oracle. We have one source Oracle database and our data warehouse is also in Oracle. I'm somewhat familiar with CDC (asynchronous would do the job) to tap into the logs, but is there anythin

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 –

Hyderabad Fresher Jobs- Oracle Security Consultant Openings in Deloitte

Job Position : Consultant – Oracle Security Name of the Organization : Deloitte Experience: 0 Years / Fresher Job Location: Hyderabad / Secunderabad Qualification : MBA – Finance / CA / BE / MCA Required : * The candidate must have

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

Large number of snowflake code tables per dimension

Ten(10) or so key dimensions(lets call them base dimensions) each has about 25 parent code tables in the 3rd normal operational source. Each code has a short and long description. In the multidimensional model If a fact table has say 3 base dimensions the

Extracting data when there is no timestamp in the source system

Guys, what are your strategies to extract data when the source system does not have any timestamps. Is there any way to still get deltas ? Thanks