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

ETL to handle deleted reference data
Hello all, I have a situation that I am unsure how to handle and would appreciate some input. My operational system allows me to add, edit and remove customers. My source operational system also constrains me from adding a cusomter with the same nam

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

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

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

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

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

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

Updating Fact Table : Best practice
Hi, Ssystem used : Windows 2003 srv SQL Server 2005 STD for the OLTP SQL Server 2005 Ent for the DW with - SSIS for the ETL - SSAS for the cube ASP.NET control to display the OLAP for the user I know theres is not "one size fits

Track Spikes
Well, outdoor starts in a couple months and I was thinking of buying a pair. I'll be doing mostly 2 mile, and maybe mile too. So, anyone have any recommendations for good distance spikes?

How to Track SCD Type 2 for Accumlating or Periodic Snapshot
Hi, I am looking to create a Periodic Snapshot fact and Accumulating snapshot fact for Backlog of orders and order completion. I tried searching in this forum as to how to model this scenario SCD type 2, but unable to find any. If I have to carry over

new scam method through PayPal
Gents! A new scamming practice has passed my email box: instead of the by now known "paid with uncovered cheque" method there is no paying with PayPal. Sound very reliable but... buyer protection and refund policy is such that the stuff may be

One Fact table having records at different granularity level
Hello, My question is just validation for an approach that we followed for one of our client requirements. Based on the requirement the FACT table should be constrcuted by the records from 2 Source table A and B. The structure of the table is as

Techniques for Updating existing fact records
I have certain cases where I need to adjust the data in the fact tables due to late arrivers etc... I wanted to get peoples opinion on what techniques work best when you have to do updates to Fact rows i.e. overwrite, adjust but keep audit

[3.039] Unstacked filename method not used when option checked.
Love the new version! I have checked the unstacked filename option for fanart, but the stacked filename is still used. Thanks for all your hard work! buzz