Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

Configuring the target

Configuring the target

Configure the target on the
Target
page of the
database ingestion
task wizard.
  1. In the
    Connection
    list, select a connection for the target type.
    You must have previously defined the connection in
    Administrator
    for the runtime environment.
    The list includes only the connection types that are valid for the load type selected on the
    Definition
    page. No connections are listed if you did not select a load type.
    If you change the load type and the selected connection is no longer valid, a warning message is issued and the
    Connection
    field is cleared. You must select another connection that is valid for the updated load type.
    After you deploy the ingestion task, you cannot change the connection without first undeploying the associated ingestion job. You must then deploy the task again.
  2. If you want to rename the target objects that are associated with the selected source tables, define table renaming rules.
    For example, you can add a prefix such as TGT_. For more information, see Rules for renaming tables on the target.
  3. If you want to override the default mappings of source data types to target data types, define data type rules.
    This feature is available only for tasks that have an Oracle source and an SQL-based target type. For more information, see Rules for customizing data type mappings.
  4. Under
    Custom Properties
    , you can specify custom properties that Informatica provides to meet your special requirements. To add a property, in the
    Create Property
    fields, enter the property name and value. Then click
    Add Property
    .
    Specify these properties only at the direction of Informatica Global Customer Support. Usually, these properties address unique environments or special processing needs. You can specify multiple properties, if necessary. A property name can contain only alphanumeric characters and the following special characters: periods (.), hyphens (-), and underscores (_).
    To delete a property, click the Delete icon button at the right end of the property row in the list.
  5. Click
    Next
    if available, or click
    Save
    .

0 COMMENTS

We’d like to hear from you!