Recently I described the Partial Join Evaluation transformation that appeared last year in 12c. I did it as an introduction for another transformation that appeared long time ago in 10.1.0.3 but was not used by default. And even in the latest 12c patchset 1 (aka 18.104.22.168.0) it is still not enabled. But it's there and you can use it if you set optimizer_features_enabled to 22.214.171.124.1 (that's not a typo!)
Introduced as an Option Oracles In-Memory option will change the world of databasing also like SAP HANA does; Since July the release is out but the search for resources and documentation is poor;
Here some useful links I found.
Concepts (found a small passage) ...
I have a business case where in a table I may have a specific value or it will have value as 'ALL'. While I query the table if particular input matches I need that particular record. If its not matching then entry with ALL should be considered and returned.
Here is the case that you have try at your end to replicate the issues.
CREATE TABLE lookup_value (
country VARCHAR2(2) NOT NULL,
department VARCHAR2(30) NOT NULL,
Some settings matter when using dbms_metadata.
Just a quick tip for everyone that is struggling to configure SharePoint Server 2013 PerformancePoint to connect to a SQL Analysis Services 2012 or 2014 cube.
After a new SharePoint Server 2013 installation, I have tried to create a new connection to my Analysis Services cube through the SharePoint Dashboard Designer, but no matter what, the Database option always shows up as empty and I can select my Analysis Services database.
One of the most frequent error messages I come across when dealing with SQL Server, particularly SQL Server 2008 R2, is Error 18056, Severity: 20, State: 29. Not only do I constantly see this error message in the SQL logs, but also in the Microsoft community forums. I often see inquiries likes, “I have SQL Server 2008 R2 SP2 installed and I see the error below. I have the most recent Service Pack installed, but the problem remains.”
When Trying to Login With Any Bi Publisher User Expect Weblogic User the BIP Unable to connect and raise the below error :-Error 500 -- Internal Server ErrorForm RFC 2068 HyperText Transfer Protocol -- HTTP/1.1In the Log :-