Using the SQL Transformation in an Informatica Developer Mapping

Using the SQL Transformation in an Informatica Developer Mapping

Logical Data Object Model

Logical Data Object Model

The logical data object model contains a unified view of the customers and orders from Affiliate A and Affiliate B. The logical data model contains the Customer logical data object and the Order logical data object. You can import a logical data object model from an .xsd file that you created in a modeling tool such as ERwin. Or, you can manually create a logical data object model in the Developer tool.
For this example, import the logical data object model from Order_Customer.xsd:
  1. Click
    File
    New
    Logical Data Object Model.
    The New Logical Data Object Model dialog box appears:
  2. Select
    Create from Existing Model File
    .
  3. Browse for the location of the Order_Customer.xsd file.
  4. Enter a name of the logical data object model. The name is Customer_Orders.
  5. Browse for the location of your project in the repository. The default is the current location.
  6. Click
    Next
    .
    A dialog box appears and lists the objects you can import from the .xsd file.
  7. Select the Customer and Order objects from the list.
    The Developer tool creates both logical data objects.

0 COMMENTS

We’d like to hear from you!