Creating Sample ETL using Informatica 8.6- Part -4

Step 4: Generating WorkFlow
1. start Workflow manager by using Start--> Programs-->Informatica Powercenter Designer 8.6--> Workflow Manager

2. click on Connections--> relational menu to create source and target connections













3. Click on New button to define the source connection properties.

4. Give the database user name and password for the source connection and save the source connection.












5. Similarly define the connection for Target.

6. Go back to Powercenter Designer window

7. Click on Mappings --> Generate WorkFlow menu










8. Click Next and select source and target connection from the drop down box










9. Click Next, Click on Configure button to define correct connections









10. Click on Properties tab to give whether to load is append or truncate and load.