Source and target database Setup in Informatica

In Oracle SQL developer, we must have database user to create database objects. In this Informatica tutorial, we have already created a database connection for the System user. Let us learn how to create new user (target database user) under SYSTEM connection

To setup target database, navigate to Start | Programs | Oracle | Application development | SQL plus.

  • Logon to Oracle with the following user credentials.
    • username : system
    • password : Admin12345.
</>
Copy
Enter user-name: system
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Create an user :

Now we have to create target user in Oracle database. Now we are going to create user called ‘Batch10am‘. Follow the steps given below to create ‘Batch10am’ user.

</>
Copy
SQL> Create user Batch10am identified by Target;
User created.

The user to login needs at least create session privilege so we have to grant this privileges to the user:

</>
Copy
SQL> Grant DBA TO Batch10am;
Grant succeeded.
SQL> show user;
USER is "SYSTEM"

SQL> Conn Batch10am/ Target;
Connected.

SQL> Show user;
USER is "BATCH10AM"

As shown above, we have created new user in Oracle database.

Creating table in database

Now we have to create a table for the user ‘Batch10am’. Learn how to create a sample table in Oracle database.

</>
Copy
SQL> Create table T_employee (Empno number(5),
  2  Ename varchar2(10),
  3  Job varchar2(10),
  4  Sal number(7,2),
  5  Deptno number(2));

SQL> Desc T_employee;
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------

 EMPNO                                              NUMBER(5)
 ENAME                                              VARCHAR2(10)
 JOB                                                VARCHAR2(10)
 SAL                                                NUMBER(7,2)
 DEPTNO                                             NUMBER(2)