Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. julianbar

    More than one fact table

    Here is an example. There is a fact table(1) with data pertaining to expenditures. In this table there is a column called budgetid which links to a budget table. There is also a column called end_date which links to a calendar. There is another fact table(2) with data pertaining to budget...
  2. julianbar

    More than one fact table

    Using informatica for a set of reports, should you try to have only one fact table. I have more than one and I am having trouble doing calculated fields where it uses fields from each table. I am thinking I should have put everyting into one fact table. Has anyone else had this problem?
  3. julianbar

    Personal Oracle sign in

    There must be something wrong with my installation These are the things I wrote down during installation Global database name cosal.skipjack SID cosal SYS account password change_on_install System account pasword = manager service name = MSD.world host MS-58906E What I am trying to do...
  4. julianbar

    Personal Oracle sign in

    I have installed personal oracle on my machine and cannot figure out the administrator,password and mangement service to enter. I have tried everything. I have written everything down during installation but nothing seems to work
  5. julianbar

    oracle joins using functions

    I have been trying to join two tables A and B I want to join them by the substr(fielda,1,2)=substr(fieldb1,2) I want to include all records in table A, even when there is no match. Can I use a plus sign using functions. When I try this it works substr(fielda,1,2)=substr(fieldb1,2) However...

Part and Inventory Search

Back
Top