Creating a mapping and executing it in new platform is conceptually the same as PowerCenter, though the user interface varies quite a bit. we look at all the steps required to create a mapping and successfully execute it in the new platform.
Connections
Connections can be created in PowerCenter Administrator web console that can be used in the Developer tool. Follow the steps given below to create a connection in the administrator:
a. Go to Administrator console
b. Go to Domains tab àConnections sub tab
c. Right click the domain name
d. Select the connection database type (such as Oracle)
e. Provide username, password, connection string details and click Finish
Physical data objects Just like in PowerCenter, to begin developing a mapping, we need to
import the source and target definitions first. These are known as Physical
Data Objects (PDOs).
a. Connect to the Model Repository
b. Open the project where you would like to create a mapping
c. Ensure connections are already created d. Add the connections in the
developer tool
1. In the Connection Explorer, right click à Click Select
Connections
2. Select Connections dialog box appears
3. In the available connections, expand the domain and select a
connection and click ">"
4. Connection will be added to selected connections. Click OK
to close the dialog
5. Connection will appear in the Connection Explorer
e. Create a new physical data object for source
1. Right click on the project/folder and click NewàData Object
2. New Wizard appears
3. Select Physical Data ObjectàRelational Data Object
4. Select a connection, where this object (table) exists 5.
Select Create data object from existing resource and click
Browse…
6. Select the table you want the object to be associated with 7.
Click Finish to save the physical data object
f. Create a new physical data object for target
Creating a mapping
Before a mapping is created, ensure that you have setup connections and have imported the physical data objects into model repository. To create a mapping, follow these steps:
a. Connect to model repository
b. Open the project where you want to create the mapping c. Create a
mapping
1. Right click on the project/folder and click NewàMapping
2. Provide a name to the mapping and click Finish
d. Drag the source and target
1. Drag the source from the object explorer into the mapping
2. Add to mapping dialog box appears
3. Select ReadàAs Independent data object(s)
4. Click OK to close the dialog
5. The PDO is added with Read_ prefix in the name
e. Drag the target
1. Drag the target from the object explorer into the mapping
2. Add to mapping dialog box appears
3. Select Write and click OK to close the dialog
4. The PDO is added with Write_ prefix in the name
f. Connect the ports from the source to the target g. Save the mapping
Mapping execution
Once the mapping is saved, right click on the workspace and click Run Mapping. If you are running mapping for the first time in this domain, you will be prompted to set a default Data IntegrationService. Click OK. In the Data Integration Services dialog box, select a data integration service andclick Set as Default and click OK to close. Mapping will run.
Comments
Post a Comment