Databases

On Wednesday May 12 celebrated the 10th Forum of Business Intelligence, which has been Dataprix Media Partner and I had the opportunity to attend.

The event was quite interesting, and it was a good opportunity to learn first-hand opinions and impressions of deployments responsible for business intelligence projects.

I find it very appropriate that most of the interventions were responsible for the area of IT or business data warehouse, as the vision and how to communicate to the person who runs a project internally is often the most realistic and that can best explain the needs, problems and what actually can be considered at the level of business success or failure of a technology project.

In the market for a Data Integration is a leading manufacturer Informatica. This company is the first independent provider of data integration software. His best-known tool and the heart of his platform is Informatica PowerCenter, which has gone through many versions, and is a reference in the world of integration.

But apart from PowerCenter, Informatica also has other tools that focus on more specific purposes, while that are integrated into the platform, and always in the context of Data Integration.

ORA-30926 error usually occurs when performing merge operations, and typically we leave something descolocados as the description of it does not give too much information about what is happening: 
ORA-30926: unable to get a stable set of rows in the source tables.

Normally this error occurs when the merge operation to target a row to be updated on it more than one row in the table source. As the engine does not know what to choose register returns an error. It is a problem of duplication in the origin table.

Example:

• We have: 
  TABLA_ORIGEN with the values 
  ID Description 
  1 'The first value' 
  1 'The value with duplicate id' 
  2 'Another value'

For obvious security reasons we can not see clear the password of the users of the database, but as an administrator user SYSTEM does have privileges to view the encrypted password:


SQL> select password from dba_users where username='SCOTT';
PASSWORD
-----------------------------
F894844C34402B67


The usefulness of this is that as we return the SELECT can be used in a sentence of password change; 


SQL> alter user scott identified by values 'F894844C34402B67';


Grant command is used to grant to user's databases generic privileges or permissions over objects.

It's syntax is: 
GRANT [system_privileges | roles] 
TO [user | role | PUBLIC] {WITH GRANT OPTION} 
to grant generic privileges