Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here are some books to start with. Toolkits you choose can be based upon whichever toolkit is in use where you are working. Most Data Warehousing professionals adhere to either Kimball's methods or Inmon's, so having knowledge about both should help you in the future. I included the other, because I respect the work of Imhoff and Geiger. I was lucky when I started, I was asked to take over maintenance of an existing Proof of Concept Data Warehouse. Good luck, and if you need any help, let us know on StackOverflow! The books I provided so far are general design and methodology books which are technology neutral. With good knowledge of these methodologies, and some specific training on tools, you should be able to work with any BI stack. You might want to try several toolkits to find one that fits your style. I have worked with the Microsoft toolkit almost exclusively, but I have touched on Cognos and Hyperion at various times in the past, and the place I am on contract to right now is switching to Informatica for ETL. They all have good and bad points, so it comes down to being adaptable and a quick learner, just like any other IT job. As a web developer, you probably used many tools depending upon what you did, i.e. you learned HTML first and then did some CSS and maybe some javascript, you may have also used tools like coldfusion. But the point is once you knew the basics, like what I presented below, the tools were secondary.<br> <a href="http://rads.stackoverflow.com/amzn/click/0471200247" rel="nofollow noreferrer" title="Kimball&#39;s Data Warehouse Toolkit">Kimball's Data Warehouse Toolkit</a><br> <a href="http://rads.stackoverflow.com/amzn/click/0471324213" rel="nofollow noreferrer">Mastering Data Warehouse Design (Imhoff, Galemmo, Geiger)</a><br> <a href="http://rads.stackoverflow.com/amzn/click/0764599445" rel="nofollow noreferrer" title="Building The Data Warehouse">Inmon's Building the Data Warehouse</a></p>
    singulars
    1. This table or related slice is empty.
    1. PONeed some information regarding data warehousing field
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USWilliam Salzman
    1. USWilliam Salzman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PONeed some information regarding data warehousing field
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIf i have to go for database course , which one should i prefer with respect to data warehousing from oracle , MSSQL , Postgresql , mysql. I mean which is more widely used in datawarehousing from ur experience. I need to do the course.
      singulars
      1. PO
      1. This table or related slice is empty.
    2. COIf you have a place in mind for your first opportunity, then by all means get familiar with the database technology that they use. Most BI toolkits are associated with one database, so that may drive what you learn first from a tools perspective, but most places I have worked including all of the large (Fortune 1000 sized) companies that I have worked for (about 3 to 5) have had more than one database technology in place. Most of the toolkits will also retrieve data from multiple databases as well. So, pick one and be prepared to learn at least a little about them all.
      singulars
      1. PO
      1. USWilliam Salzman
    3. COWhat size company are you targeting for employment. Most large companies will use DataStage, Cognos, Teradata, AbInitio, Informatica, etc. Middle sized companies and companies just starting into BI will likely use Microsoft tools (SSIS, SSAS, SSRS) since the cost is lower, although some very large companies also use these. Smaller companies either have not started into BI or may be using the open source toolkits (Pentaho, mySql, Kettle, etc). Of course, if a person used a toolkit in one place then is picked to start BI at another company, they will most likely use the tools they already know
      singulars
      1. PO
      1. USWilliam Salzman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload