Search over 650+ Posts

May 20, 2015

TCA Process flow for managing, searching, creating, and updating customer information


High level process flow for managing, searching, creating, and updating customer information


Source - Oracle TCA Documentations

Jan 2, 2015

NVL2 with Oracle database



Oracle has further enhanced functionality of NVL with NVL2



NVL2 lets you determine the value returned by a query based on whether a specified expression is null or not null. If expr1 is not null, then NVL2 returns expr2. If expr1 is null, then NVL2 returns expr3.

The argument expr1 can have any datatype. The arguments expr2 and expr3 can have any datatypes except LONG.

What If the datatypes of expr2 and expr3 are different:

If expr2 is character data, then Oracle Database converts expr3 to the datatype of expr2 before comparing them unless expr3 is a null constant. In that case, a datatype conversion is not necessary. Oracle returns VARCHAR2 in the character set of expr2.


If expr2 is numeric, then Oracle determines which argument has the highest numeric precedence, implicitly converts the other argument to that datatype, and returns that datatype.

The following example shows whether the income of some employees is made up of salary plus commission, or just salary, depending on whether the commission_pct column of employees is null or not


Dec 31, 2014

Oracle Endeca Information Discovery

What is Oracle Endeca Information discovery Tool - Oracle Endeca Information Discovery is an enterprise data discovery platform for advanced, yet intuitive, exploration and analysis of complex and varied data.
Information is loaded from disparate source systems and stored in a faceted data model that dynamically supports changing data. This integrated and enriched data is made available for search, discovery, and

analysis via interactive and configurable applications. Oracle Endeca Information Discovery enables an iterative "model-as-you-go" approach that frees IT from the burdens of traditional data modeling and supports the broad exploration and analysis needs of business users.



Components of Oracle Endeca -


Integrator Designer -Integrator Designer provides an easy-to-use interface you can use to create graphs for loading and updating your data quickly.
A graph is essentially a pipeline of components that processes the data.

Integrator Server -Information Discovery Integrator Server provides a runtime environment for the graphs.Integrator Server is not required in order to load data into the Endeca data domains. In other words, you can run Integrator Designer independently, and it does not require Integrator Server to do its work.You use Integrator Server only if you are running graphs in an enterprise-wide environment.

Oracle Endeca Information Discovery Studio is a web-based enterprise data discovery platform for advanced, yet intuitive, exploration and analysis of complex and varied data. Studio enables an iterative "model-as-you-go" approach that frees IT from the burdens of traditional data modeling and supports the broad exploration and analysis needs of business users.

Studio includes the Provisioning Service, which allows business analysts to create Studio applications by uploading their own data directly from spreadsheets.

Oracle Endeca Server is the core search-analytical database. It organizes complex and varied data from disparate source systems into a faceted data model that is extremely flexible and reduces the need for upfront data modeling. This highly-scalable server enables users to explore data in an unconstrained and impromptu manner and to rapidly address new questions that inevitably follow every new insight.

Stay tune for more information on Oracle Endeca Information Discovery.