"Cannot find the javaw.exe"

While running RCU
Error Message : "Cannot find the javaw.exe"

Action:

JAVA_HOME is a regular path when ever we install JDK in our machine and if it is not supporting to other tools.

ODI_JAVA_HOME we need to set as same JDK path because ODI required Java engine and it is backgrond process for ODI studio

Process:

1. Right click on computer 
2. Go to Properties
3. Advanced settings
4. Click on Environment variables
5. Click on new
6. Set values      --- Windows

set JAVA_HOME=C:\Program Files\Java\jdk1.7.0_25

set ODI_JAVA_HOME=C:\Program Files\Java\jdk1.7.0_25 

1.                     --- LINUX/UNIX
   export JAVA_HOME=/usr/java/jdk1.7.0_25
   export ODI_JAVA_HOME=/usr/java/jdk1.7.0_25

unable to access or modify the system registry

Error Message : unable to access or modify the system registry

Action:

Could you please open your Command Prompt with Administrator Privileges in order to run command Prompt with Admin Privileges

   Goto ----> start ----> All Programs -----> Accessories ---> Right Click on Command Prompt and select "Run as Administrator" option

Error: Could not find or load main class ûjar

Error Message : Could not find or load main class ûjar
Which means your java not properly installed . To resolve issue - reinstall JAVA it.

How to find version of Oracle?

SELECT version FROM V$INSTANCE; -- we can get exact version of database
/
SELECT * FROM V$VERSION; -- we can get detail information along with version (like bit - windows 32bit or 64 bit ....)

How to unlock User and Unexpire User in Oracle DB?

• Login as Admin
  SQL> connect / as SYSDBA
  Connected
• How to find accounts are expired and locked?
  select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';
• Unexpired Accounts 
  once an account has been expired, it can only be alter by assigning it a new password:
  ALTER USER HR IDENTIFIED BY HR;
• Unlock Accounts
  ALTER USER HR ACCOUNT HR;
• Disable default password expiry
  this all depends on the profile a user belongs to, to disable password expiry for all users assigned the default user profile do this:
  ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Unlock Account from SQL developer

        Log in as sys or system, then often three other user node and right click the hr user. Select edit from the           context menu and remove the check mark from 'lock account' 

Performance Tuning

Performance Tuning

The following things will increase performance at ODI level

• Select Appropriate Knowledge module to Load data
• Execution of Joins and Filter in appropriate area (i.e., Source/Stage/Target)
• Increase Array Fetch size and Batch Fetch size of the data server
• select different schema for data and work in "Physical architecture" 
• Enable Archival Logging
• Truncate mode no for temporary tables
• CDC log based improves performance

Declarative Design

Conventional ETL

Consider, for example, a common case in which sales figures must be summed over time for different customer age groups. The sales data comes from a sales management database, and age groups are described in an age distribution file. In order to combine these sources and then insert and update appropriate records in the customer statistics systems, you must design each step, which includes

1. Load the customer sales data in the engine

2. Load the age distribution file in the engine

3. Perform a lookup between the customer sales data and the age distribution data

4. Aggregate the customer sales grouped by age distribution

5. Load the target sales statistics data into the engine

6. Determine what needs to be inserted or updated by comparing aggregated information with the data from the statistics system

7. Insert new records into the target

8. Update existing records into the target

Conventional ELT

With declarative design, you just need to design what the process does, without describing how it will be done.

In our example, what the process does is

• Relate the customer age from the sales application to the age groups from the statistical file

• Aggregate customer sales by age groups to load sales statistics