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

Source and target parameters

Source and target parameters

You can configure the file name pattern, folder, and table parameters for sources and targets that a file ingestion task reads from or writes to.
You can use one of the following types of variables to configure a parameter:
  • System variables
  • User-defined variables
You cannot run a task with user-defined variable from the user interface. The value of the user-defined variable must be passed using the job resource of the Mass Ingestion Files REST API. For more information, see job.

Using system variables to add source and target parameters

Use system variables to add parameters to task sources and targets.
  1. Click
    Add Parameter
    next to the input field, such as
    Source Directory
    or
    Target Directory
    on the
    Source
    or
    Target
    tab of the task wizard. .
    The
    Add Parameters
    window appears.
    The Add Parameters window appears. It has two columns. The system variables are on the left and the expression that you build from them shows on the right.
  2. Select the required variable from the
    System Variables
    column and click . The selected system variable appears on the
    Expression
    column. Repeat this procedure to select multiple system variables.
    When using a system variable within a task, it should be formatted as
    ${systemvariablename}
    .
    The following table describes the system variables:
    System Variables
    Description
    Expression
    BadFileDir *
    Directory for reject files. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMBadFileDir}
    CacheFileDir *
    The location for the cache file.
    ${$PMCacheDir}
    Date **
    The current date in ISO (yyyy-MM-dd) format.
    ${system.date}
    Day **
    The day of week
    ${system.day}
    ExtProcDir *
    Directory for external procedures. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMExtProcDir}
    Hours **
    Hours
    ${system.hours}
    JobId
    The id (or job number) of the current job.
    ${system.jobid}
    LookupFileDir *
    Directory for lookup files. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMLookupFileDir}
    Minutes **
    Minutes
    ${system.minutes}
    Month **
    Numerical month
    ${system.month}
    Name
    The name of the current Project.
    ${system.name}
    RootDir *
    Root directory accessible by the node. This is the root directory for other service process variables. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMRootDir}
    RunId
    The id when a job is run.
    ${system.runid}
    Seconds **
    Seconds
    ${system.seconds}
    SessionLogDir *
    Directory for session logs. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMSessionLogDir}
    SourceFileDir *
    Directory for source files. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMSourceFileDir}
    StorageDir *
    Directory for run-time files. Workflow recovery files save to the $PMStorageDir configured in the PowerCenter Integration Service properties. Session recovery files save to the $PMStorageDir configured in the operating system profile. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMStorageDir}
    TargetFileDir *
    Directory for target files. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMTargetFileDir}
    TempDir *
    Directory for temporary files. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMTempDir}
    Timestamp **
    The current date and time in ISO (yyyy-MM-dd HH:mm:ss) format.
    ${system.timestamp}
    WorkflowLogDir *
    The location for the workflow log file.
    ${$PMWorkflowLogDir}
    Year **
    Year
    ${system.year}
    * Values are fetched from the Data Integration Server.
    ** Time zone is the Secure Agent time zone.
  3. Click
    OK
    .
    The expression appears in the input field.

Using user-defined variables to add source and target parameters

Use user-defined variables to add parameters to add sources and targets.
  1. Click an input field, such as
    Source Directory
    or
    Target Directory
    on the
    Source
    or
    Target
    tab of the task wizard and enter the variable. The variable should be formatted as
    ${systemvariablename}
    .
    Enter the user-defined variable
  2. Click
    OK
    .
    The expression appears in the input field.

0 COMMENTS

We’d like to hear from you!