How To Build A Data Warehouse
How To Build A Data Warehouse
how strong is our economy????
The government say our economy is strong?
All i see is small businesses collapsing due to cheap imports
Large warehouses being built to store all these imports
No new jobs in manufactureing or serviceing
The main jobs now seem those that sit people at computers all day entering data taking calls …no actual productive jobs just data shifters.
the service industry no longer exits as everything is bought new rather than repaired
Cheap labour brought in from other countrys to support fat cat businesses so they can make more profit.
this country is turning into a black hole economy
london may be booming due to inflated wages but the rest of us are fast going down the plughole
sorry folks UK economy
(Um, guys, “Rusty” is an American name…)
Our economy is going gangbusters.
We have the largest economy in the world and we’re growing (that’s hard to do). We have the world’s largest per-capita income in the world (except for a few really small countries with great industries, like the Bahamas)–larger than Kuwait!
Our unemployment rate is close to the lowest in history.
Our tax revenues have increased quite a bit despite tax cuts by this administration, and our budget deficit has been going down slowly over the last 5 years despite the so-called out-of-control spending (this from the budget and economic affairs office).
China and Japan are buying up our bonds (they think we’re the best investment in the world). North Korea is not counterfeiting Chinese currency, they’re copying ours. It must be worth more to them.
The housing bubble has been bursting now for three years. So much for that conspiracy theory.
We’re sending jobs over seas by the thousands. The trouble with that theory is that our own unemployment is still going down, too. I guess that means we can’t help but create jobs all over the world. (How many countries can say that?)
How To Build A Data Warehouse
Salesforce Data Replication Made Easy
Need to perform exact schema and data replication to your database? DBSync for Data Synchronizer is the right tool for you.
Why do you need it?
- To build a data warehouse or create complex reports using BI tools
- To perform integration with other inhouse applications like Customer Master databases, ERP or other databases
- To perform offline data scrubbing and migration before final migration to Salesforce.com.
How does it work?
DBSync is a simple application which understands data structures in Salesforce.com and your database (any JDBC complaint database like MySQL, SQLServer, Oracle, DB2 or PostGresSQL) and can auto-create both schema and data in your database.
DBSync provides 3 ways for driving data to and from a database:
- Using a web interface to define your integration “Profiles” end points, and select the Salesforce.com objects to synch-up.
- Batch interface – once you have setup your profiles, you can use pre-configured batch scripts (for Windows or Linux) to initiate data and schema transfer from Salesforce.com to database or data transfer from database to Salesforce.com.
- Real-time integration from Salesforce.com to database – DBSync leverages Salesforce.com outbound messages to intercept and interpret inbound message and then route it to the target database.
The initial setup and install time is pretty quick. A person familiar with databases should be able to install and setup in less than an hours time.
Replicating your Salesforce to your database has never been so easy. Create a backup or create a datawarehouse easily with DBSync.
- Auto-create Salesforce Object Schema into your database
- Replicate Salesforce Objects in Batch or Real-time into your database
- Create or update Salesforce records from your database tables
- Be up and running in minutes rather than days
More information can be found at Salesforce and database sync page.
About the Author
Rajeev Gupta, CEO With his background in CRM technology adoption, Rajeev developed a solid expertise in building on-demand integration solutions and CRM data mining applications with companies such as Google, Amazon, Microsoft, Salesforce. Rajeev earned his Master’s and Bachelors degrees in Electrical Engineering and an MBA from Owen School of Management, Vanderbilt University.
How do I calculate the cost for inventory per sq foot?
We have scratch and dent inventory that can sit for months with no movement. We’re also getting low on warehouse space. I would like to calculate the cost each month for each square foot that is taken up by the equipment. Thoughts on how to do this?
My thought: Get 6 or 12 months of financial data and average the costs for building maintenance, utilities, employee salary & benefits, etc and then divide that by the square footage in the warehouse.
Problems:
1) we own this building, so we don’t pay rent. Shouldn’t there be some type of cost here though?
2) do i include all employee’s salary/benefits at this location or just warehouse employees?
3) What do I use as my warehouse space? The building as a 1 level facility holds 115,000 sq feet. Including the vertical racks its 140,000.
Any thoughts would be much appreciated!
I would think you have to include ALL costs associated with that building. Costs include utilities, employee pay and benefits at the location plus administrative costs associated with employing these people, cost of the building over sq footage over the useful life of the building, maintenance, property taxes etc. You have to dig up a lot of hidden and intangible costs of building ownership. The building has 140,000 sq ft of storage space. If the building has a useful life of 20 years and you paid $2,000,000 for it, the storage cost is $0.714 per square foot per year. Add to that your variable costs of pay & benefits. You may find it cheaper to dump the inventory after its value becomes less than what it costs to store it. You want to include 100% of the building’s square footage (include office space, rest rooms, etc).
Starting a Data Warehouse
