Create a simple mapping in Informatica

1. Open Informatica Repository Manager and select Configure Domains under Repository menu

2.       Click on New

3.        Provide proper connection details. (6005 is the default port)

4. Select  the associated repository ie created under Informatica admin console. Click OK

5. Connect the Repository

6. Provide Connection credentials

7. Create a new folder under Folder menu

8.    Enter folder name and click OK

9.Open Informatica Designer and  Right click on the folder and select Open

10. Select Import from Database under Source Menu

11.       Click on browse button

12. Create a new System DSN ODBC connection

13. Select Oracle Wire Protocol

14.Provide proper connection details and click on test connection

15. Provide username and password. Click OK

16.Once connection is successful click Apply and OK

17. Create connection for Target as well and click OK

18. In the ‘Import tables’ select connection to source

19.       Provide database connection details and click on connect.

20.   Select Employee table and click OK

21. In the TARGET database schema, create a Target Table as follows

22. Under Targets menu select Import from Database

23. Select Target connection, Provide database connection details and click on OK

24. Select EMPLOYEES table and click OK

25. Under mappings menu select Create

26. Enter a mapping name

27. Drag  the source into the editor window

28. Under Transformation menu select create

29. Select Expression transformation from the drop down and click on create and then click on Done

30. Drag all columns from Source Qualifier to Expression.

31. Double click on expression transformation and click on new column button.

32. Enter column name and select as output port. Select the expression builder for the Fullname column.

33. Enter the concatenation expression as below and click validate and then OK

34. Click apply and then OK

35. Drag the target table into the mapping editor

36. Map all columns from Expression transformation to Target table

37. Save the mapping. Make sure your mapping is valid.

38. Open workflow manger and select Relational under Connections menu

 39. Select new

 40. Select Oracle and click OK

 41. Provide connection details and click OK

 42. Select new and create a connection for Target.

43.Provide connection for Target and click OK

 44. Under Tasks select create

 45.Select session from the drop down and provide a session name and click create

 46. Select the mapping and click OK

 47. You can see a session created

 48. Under workflows menu select create.

 49. Enter workflow name

 50. By default, A workflow is created with a start task

 51. Drag the session into the workflow editor.

 52. Select link task

 53.Draw the link from start to session

54. Double click on session

 55. Under mapping tab select  Source connection

 56. For target as well select the connection. Click on edit

 57. Select target connection.

 58. Save the workflow

 59. Right click on the workflow and start workflow

 60. The workflow monitor will open automatically and you can see workflow running.

 61. Wait till the workflow succeeds.

 62. Query the table in target database