![Mapping Creation in Informatica PowerCenter issues-after-qlikview-version-upgrade-on-passive-node-of-production-servers](https://www.s-squaresystems.com/wp-content/uploads/Mapping-Creation-in-Informatica-PowerCenter.png)
Source Analyzer:
-
- Go to tools menu >select Source Analyzer as shown in below screenshot.
![Picture169](https://www.s-squaresystems.com/wp-content/uploads/Picture169.png)
-
- Go to sources (from menu bar) To import the source tables from database. As shown in below screenshot.
![Picture170](https://www.s-squaresystems.com/wp-content/uploads/Picture170.png)
-
- Provide the user ID and Password to connect to the DB and to import required tables.
![Picture171](https://www.s-squaresystems.com/wp-content/uploads/Picture171.png)
![Picture172](https://www.s-squaresystems.com/wp-content/uploads/Picture172.png)
Target Designer:
-
- Go to tools menu >select Target Designer as shown in below screenshot.
![Picture173](https://www.s-squaresystems.com/wp-content/uploads/Picture173.png)
-
- Go to target (from the menu bar) To import the target tables from the database. As shown in below screenshot.
- Provide the user ID and Password to connect to the DB and to import required tables.
![Picture174](https://www.s-squaresystems.com/wp-content/uploads/Picture174.png)
-
- Will see the Source and Targets are imported from our data base.
- Drag the source table from source analyser, target table from target analyser in Designer page.
Mapping Designer:
-
- Go to Mapping> (from tools bar) to create new Mapping as shown below screenshot.
![Picture175](https://www.s-squaresystems.com/wp-content/uploads/Picture175.png)
-
- Create New Mapping with respective name E.g. (m_booksmapping), m_ is naming convention for mapping creation.
![Picture176](https://www.s-squaresystems.com/wp-content/uploads/Picture176.png)
-
- Drag and Drop target and source in mapping from the respective Windows in a designer as shown below screenshot.
- Connect all the column fields from source to source qualifier in mapping designer as shown in below screen shot.
![Picture177](https://www.s-squaresystems.com/wp-content/uploads/Picture177.png)
-
- Connect all the column names from source qualifier to target in mapping designer as shown in below screenshot.
![Picture178](https://www.s-squaresystems.com/wp-content/uploads/Picture178.png)
Save mapping.
Workflow Manager:
-
- Go to Work Flow manager –>to create workflow and task for the session for the mapping process.
![Picture179](https://www.s-squaresystems.com/wp-content/uploads/Picture179.png)
-
- Create new workflow: Give the name to workflow with given naming convention wf_booksworkflow and then click on ok.
![Picture180](https://www.s-squaresystems.com/wp-content/uploads/Picture180.png)
-
- Created workflow will be shown in below screen shot.
![Picture181](https://www.s-squaresystems.com/wp-content/uploads/Picture181.png)
Session:
Go to Work Flow manager à to create the task for the session in the mapping process.
![Picture182](https://www.s-squaresystems.com/wp-content/uploads/Picture182.png)
-
- Create new Session: Give a name to session with given naming convention s_bookssession and then click onÂ
![Picture183](https://www.s-squaresystems.com/wp-content/uploads/Picture183.png)
-
- After creating session for a mapping, it will allow to choose respective mapping click on ok.
![Picture184](https://www.s-squaresystems.com/wp-content/uploads/Picture184.png)
-
- Now we will get a window for the created task as shown below, click on done.
![Picture185](https://www.s-squaresystems.com/wp-content/uploads/Picture185.png)
EDIT TASK:
We have to edit task such that make sure all the source and targets must be connected to the respective database as shown in below screenshot and click on OK.
![Picture186](https://www.s-squaresystems.com/wp-content/uploads/Picture186.png)
NOTE: If the target table contains any primary keys then target load type should not be Bulk.
-
- Create a link between session and worklet as shown in below screenshot. Save the workflow designer.
![Picture187](https://www.s-squaresystems.com/wp-content/uploads/Picture187.png)
-
- Go to workflows and click on start workflow to start workflow for the mapping process.
![Picture188](https://www.s-squaresystems.com/wp-content/uploads/Picture188.png)
Work Flow Monitor:
-
- Click on workflow monitor to see the output of mapping result (status of mapping should be succeeded)
![Picture189](https://www.s-squaresystems.com/wp-content/uploads/Picture189.png)
-
- To check the task Details, right click on the session to get run properties. Please find the below screenshot.
![Picture190](https://www.s-squaresystems.com/wp-content/uploads/Picture190.png)
OUTPUT of Sample Mapping:
-
- Source Table Before Mapping Process
![Picture191](https://www.s-squaresystems.com/wp-content/uploads/Picture191.png)
-
- Below is the OutPut (Target table) After Mapping Process
![Picture192](https://www.s-squaresystems.com/wp-content/uploads/Picture192.png)