Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a ERP system that uses a DB in postgres, each table has many rows and we want to build data warehouse (data warehousing). Also we want to add BI using ETL

where would begin? would use schemes or two separate databases?

share|improve this question

closed as too broad by Jon Seigel, dezso, JNK Aug 1 '13 at 16:52

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

Hire someone who is experienced in this field? – dezso Aug 1 '13 at 16:40
This is many orders of magnitude too broad to be answerable here. There are dozens of very large books that only cover small parts of what you are asking. If you have a specific question about a specific aspect of a specific step or process in developing a DW, please feel free to ask it. Asking for advice on how to build a DW with absolutely no context or limits is not going to fly. – JNK Aug 1 '13 at 16:53
up vote 4 down vote accepted

I would suggest that you first need to do some study. Your questions suggest that you are unclear on the issues needed for building a data warehouse.

Read books such as Ralph Kimball's "Data Warehouse Toolkit" as a starting place to understanding the issues you are facing.

Likewise, you search through some of the online resources to learn the parts and processes. For example:

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.