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?
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.