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

OData Consumer Connector

OData Consumer Connector

Mapping with Custom Headers Example

Mapping with Custom Headers Example

You can use custom headers during write operation. Map the custom header port when you want to use custom headers.
Use the following format to specify a custom header field:
name1 "=" value1 ";" name2 "=" value2
Perform the following steps to map flat files that use custom headers:
  1. Create a flat file that contains custom headers. For example, create a flat file named A with custom headers.
    The following image shows a flat file with custom header defined: The image shows a flat file with custom headers defined.
  2. Create a flat file that contains data to be written to OData Consumer. For example, create a flat file named B, that contains data to be written to OData Consumer.
    The following image shows a flat file that contains data to be written to OData Consumer: The image shows the flat file that has data to be written to OData Consumer.
  3. Place the flat file A and flat file B in a folder.
  4. In
    Informatica Intelligent Cloud Services
    , go to
    Data Integration
    tab and click
    New
    .
  5. Under
    Mappings
    , click
    Create
    .
  6. Select the flat file A from the flat file connection.
  7. Under
    Formatting Options
    tab, specify pipe
    |
    as the delimiter.
  8. Select the flat file B from the flat file connection.
  9. Under
    Formatting Options
    tab, specify comma
    ,
    as the delimiter.
  10. Select
    Joiner
    from the
    Design
    tab.
  11. Join the flat file A and the flat file B using a join condition. For example, the join condition is
    nos=no
    . The flat files used to define a join condition are known as
    Master
    and
    Detail
    . For example, flat file A is
    Master
    , and flat file B is
    Detail
    .
    The following image shows the
    Master
    and
    Detail
    joined by the
    =
    operator:
  12. Select an OData Consumer connection and select the target object to which you want to write the custom headers. For example,
    airlines
    is the target object.
  13. In the
    Advanced
    section in target properties, select
    Use Custom Headers
    check box.
  14. Select
    Field Mapping
    and map the joiner output fields to the target object fields.
  15. Save and run the mapping.

0 COMMENTS

We’d like to hear from you!