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:
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:
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:
Place the flat file A and flat file B in a folder.
In
Informatica Intelligent Cloud Services
, go to
Data Integration
tab and click
New
.
Under
Mappings
, click
Create
.
Select the flat file A from the flat file connection.
Under
Formatting Options
tab, specify pipe
|
as the delimiter.
Select the flat file B from the flat file connection.
Under
Formatting Options
tab, specify comma
,
as the delimiter.
Select
Joiner
from the
Design
tab.
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:
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.
In the
Advanced
section in target properties, select
Use Custom Headers
check box.
Select
Field Mapping
and map the joiner output fields to the target object fields.