"Hello World" ... First Map Using Informatica Developer

In last blog we have seen how to connect to Informatica Developer, and today is time for our first map using Informatica Developer.

One you are connected to Informatica Developer, right click on Repository Service, and you will get option to create new project or import an existing project.

Here, we are going to create a new project "HelloWorld"

Once you click on Project, new window will appear which will ask you to give name for your project.

In this case, I have given a name "HelloWorld". Once you click on Finish, new project called "HelloWold" will appear at left panel. Right click on new Project "HelloWorld" and create a new mapping as shown below

Give new mapping a same name called "HelloWorld".. we will keep mapping simple with Source and a Target.
I have created table called EMP2 having same structure as EMP in scott schema under orcl db as below.
------------------------------------------------------------------------------------
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: scott
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> create table EMP2 as select * from EMP where 1=2;

Table created.

SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

------------------------------------------------------------------------------------

We will import source EMP and target EMP2 from Scott schema in ORCL database as below.

To import new Source \ Target as a Physical Object in Mapping..
1. Right click on mapping "HelloWorld"
2. Click on New --> Other

 

3. New window will appear which will give different options. Out of available options, select Relational Data Object to import new Source \ Target from Physical RDBMS schema.

4. New window will appear as below after you click on "Relational Data Object". Choose available connection [if its not then create a new one].

In this case "MyConnection" object was already available.

5. Once you choose the connection, new window will appear to select the tables \ objects from available schema for particular connection.

6. Import EMP and EMP2 and treat them as source and target for your mapping.
7. Once you import both tables, it will appear at left panel of your mapping window as below

8. Drag both EMP and EMP2 at your mapping panel; treat them as source and target and make port connection between them.

9. We have done with our first task and now we have to validate it and run it.

10. Right click on mapping panel and validate the mapping [you will get the validate option once you right click on mapping window]

11. Once mapping is valid, again right click on the panel and run the mapping.
12. Log file will show that mapping completed successfully
13. Check the target table count and results are as below.
--------------------------------------------------------
C:\Documents and Settings\Administrator>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 15 15:07:19 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: scott
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select count(*) from emp2;

  COUNT(*)
----------
        14

SQL>
-----------------------------------------------------------
Here, new things which we observed is we do not require Source Qualifier and Workflow \ Session.

More on this after some days...