Source and target database Setup in Informatica

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.

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.

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:

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.

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)