You must create schema file to define each Data Table added in Datatables.tbl file.
You can use schema file to configure each Datatable parameter. The schema file name must be similar to the value mentioned in the TABLE_NAME Field of Datatables.tbl file. You must create a schema file in the format shown below:
Header Name
Allowable Value
Remarks
ISKEY
Y,N, Any Character
When you type Y, the Key Field is active. Define Key field, when you want to add Upsert operation for Datatable.
ISNULLABLE
Y,N, Any Character
When you type Y, the field is defined as mandatory or non-nullable in Informatica Cloud DSS Task.
ISFILTERABLE
Y,N, Any Character
When you type Y, the field is displayed in the data filters tab for the selected Datatable.
DATATYPE
Integer, string, date, Boolean,
long, float
Any data type mentioned in the ‘Allowable Value’ is supported in the schema file.
PRECISION
<Valid Number>
Set the precision required using this field. Note: Precision for string data type is variable, while for other data types it is constant.
SCALE
<Valid Number>
The scale value should be equal to precision value.
FLD_DISPLAY_NAME
<Characters A to Z or a to z.
Only special character allowed is Underscore.>
The field name that is visible in Informatica Cloud UI. Alphabets (both Caps and small) are allowed. Only underscore ’_’ special character is allowed.
FLD_NAME
<Any MS Latin1 Characters>
This name is used for RPC call to the Webservice Endpoint.
FLD_DESCRIPTION
-
Field description
Sample Schema file
Perform the following steps to create a sample schema file.
1 To create a schema file copy and paste the following sample data in a blank text file:
ISKEY","ISNULLABLE","ISFILTERABLE","DATATYPE","PRECISION","SCALE","FLD_DISPLAY_NAME","FLD_NAME","FLD_DESCRIPTION" "Y","N","Y","integer",10,10,"IndIdNbr","IndIdNbr","Lead Id" "N","Y","Y","string",256,256,"LetterType","LetterType","Typoe of Letter" "Y","Y","Y","date",256,256,"LatestLtrDate","LatestLtrDate","Latest Letter Date" "N","Y","Y","string",256,256,"ModelMatch","ModelMatch","Model Type" "N","Y","Y","string",256,256,"CampaignName","CampaignName","Name of the Campaign" "N","N","Y","date",256,256,"PromoDate","PromoDate","Date of Promotion" "N","Y","Y","long", 15, 15,"TmOperatorId","TmOperatorId","Operator Id"
2Name the file with the file name extension .SCH.
3Click Save.
Getting the Schema Names
Perform the following steps to get the schema names for quoteV2 and quoteV2LineItem using BigMachines portal:
1Go to the BigMachines portal.
The following image displays the BigMachines portal page:
2Click Admin.
The Administration platform page appears.
The following image displays the Adminstration platform page:
.
3Select Interface Catalog from Integration Platform.
4Select InterfaceType as REST and select the Interface name where the transactions are present. The following image shows the Interface catalog:
5 Double click on the Interface Name that you selected in the previous step.
The JSON response opens in the new window. The following image displays the JSON response page:
6Search for the "rel" : "child" keyword in the JSON page. The following image displays the JSON response page:
7Find the Transaction Schema Name and Transaction Line Item Schema Name by using the href value.
- The name that is present between /rest/v1/ and /{_id} is the transactionSchemaName.
- The name which is present after /{_id/}is the transactionLineItemSchemaName.
Then, commerceDocumentsOraclecpqoTransaction is the value for Transaction Schema Name connection attribute and transactionLine is the value for Transaction Line Item Schema Name connection attribute.
.
