Developer Tool Guide

Back Next

Nonrelational Data Objects

Import a nonrelational data object to use in a mapping, mapplet, or profile. A nonrelational data object is a physical data object that uses a nonrelational data source.

You can import nonrelational data objects for the following connection types:

Adabas

IMS

Sequential

VSAM

When you import a nonrelational data object, the Developer tool reads the metadata for the object from its PowerExchange data map. A data map associates nonrelational records with relational tables so that the product can use the SQL language to access the data. To create a data map, use the PowerExchange Navigator.

After you import the object, you can include its nonrelational operations as read, write, or lookup transformations in mappings and mapplets. Each nonrelational operation corresponds to a relational table that the data map defines. To view the mapping of fields in one or more nonrelational records to columns in the relational table, double-click the nonrelational operation in the

Object Explorer

view.

For more information about data maps, see the PowerExchange Navigator Guide
.

Before you work with nonrelational data objects that were created with Informatica 9.0.1, you must upgrade them. To upgrade nonrelational data objects, issue the infacmd pwx UpgradeModels command.

When you run a mapping that includes an Update Strategy transformation and writes data to a nonrelational target, the mapping might fail with an error message. The message indicates that the target table has no keys, even though the data map for the target has keys defined.

Physical Data Objects

Importing Nonrelational Data Objects

Creating a Read, Write, or Lookup Transformation from Nonrelational Data Operations

Rename Saved Search

Table of Contents

Developer Tool Guide

Developer Tool Guide

Nonrelational Data Objects

Nonrelational Data Objects