Finding Repository Version in ODI 11g

• Connect to the Workrepository using sqldeveloper or sqlplus or any other tool
• Execute the following query:
• select REP_VERSION  from SNP_LOC_REP
• The result shows the repository version.

Show Desktop Icon

1. Click Start, click Run, type notepad in the Open box, and then click OK.
2. Carefully copy and then paste the following text into the Notepad window:
   [Shell]
   Command=2
   IconFile=explorer.exe,3
   [Taskbar]
   Command=ToggleDesktop
3. On the File menu, click Save As, and then save the file to your desktop as "Show desktop.scf". The Show desktop icon is created on your desktop.
4. Click and then drag the Show desktop icon to your Quick Launch toolbar.

Difference in Optimization and Execution Context in ODI

There are two types of Contexts in ODI 11g.

• Optimization Context
• Execution Context

The basic difference between them are Optimization context is used while designing i.e. when the target  is pulled this context provides the information on the target table and columns. The execution context is used when the interface is executed.

Wonder why it is called as Optimization context. I feel it should be called as Design Context.

Oracle Unlock Account

To Resolve the Oracle error ora-28000 Account Locked in Oracle 10g, Do the following

1) Connect to the sys as sysdba and issue the following commands
      a) Alter user <username> account unlocked;
      b) grant connect, resource to <username>;
  
Account is unlocked now. Connect to the <username>. You may be prompted for password change. If prompted you can retype the old password itself.