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...
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?
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.