Informatica ActiveVOS
- Informatica ActiveVOS 9.2.5
- All Products
Data Type
| Description
|
---|---|
Any
| Use the Any data type if you want to declare fields that are process objects without setting the Reference To option. This means that the data type is an object, but you do not need to specify which object it is. If you use the Any object, you cannot drill further into the object.
Some services return large amounts of data, but you may need only a small percentage of it. Use the Any data type to model all the data returned in to just a few fields.
For example, when you use a REST proxy, it passes a received payload as input and then responds to this payload. The REST proxy would do some processing on the request or response, and it would not have to understand the whole message.
A second example would be supporting heterogeneous lists. While simple REST APIs tend not to include heterogeneous lists, SOAP-based APIs do. For example, a SOAP API might have a "query" operation that returns data that depends on the query itself. Here, the static type of the output for the "query" operation would be an objectlist of the any type.
A third example is calling a service that returns records that match a query. Each record can have a unique set of fields, so those could not be known at design time. At runtime, each field would just be turned into a child element of the record element, using a tagname that corresponds to the field name. The converted JSON returned as output might be:
|
Attachment, Attachments
| Use Attachment and Attachments to a process to pass through an attachment and extract data like file size and file name using functions on the response.
The default Maximum File Size is 5,242,880 bytes and the default Maximum Number of Files is 10. You can change these field properties.
If you run a
process on the cloud server, do not use an attachment whose size is more than the default 5,242,880 bytes. The cloud server cannot process attachments that are greater than 5,242,880 bytes.
|
Checkbox
| A checkbox allows the user to make a true/false decision. This decision can alternatively be displayed as Yes/No or No/Yes For example, you could use a checkbox to indicate if an address is a work phone number or a home phone number.
As an alternative, a checkbox can be displayed as yes/no values.
|
Currency
| A currency field contains a monetary value. In addition to numbers and perhaps a decimal point, you can also use commas where they are needed. Commas are always optional.
|
Date
| The output date is in UTC, and output date and time are in ISO 8601 format. For example, if you enter an input date of 2016-03-29, and use the currentTime XQuery function to get date and time values, you see the following output:
The following are sample valid date values:
If you do not pass a time zone, Informatica Process designers assumes the time to be in UTC.
If you need to format the way in which the date appears, see
Formatting Dates, Times, and Numbers .
|
Date Time
| When selecting a Date Time field in a
process , the user can select the time from a list.
The output time is in UTC, and output date and time are in ISO 8601 format. For example, if you enter an input date of 2016-03-29, and use the currentTime XQuery function to get date and time values, you see the following output:
The following are sample valid dateTime values:
If you do not pass a time zone, Informatica Process designers assumes the time to be in UTC.
If you need to format the way in which the date and time appears, see
Formatting Dates, Times, and Numbers .
|
Email
| The content of this field is an email address.
|
Formatted Text
| The format is a representation of the kind of character a user can type within the text being entered.
Note : the "-" is not listed. If you can type this character, it is displayed when the user sees the step.
|
Image
| A field that will contain an image. This is most often used when an automated action retrieves an image.
|
Integer
| A positive or negative whole number.
Use the
Digits field to enter the maximum amount of numbers the user can type.
Numeric values display using the format of the user's locale.
If you need to format the way in which the number appears, see
Formatting Dates, Times, and Numbers .
|
Multi-Select Picklist
| A picklist field from which the user can select one or more rows. To select multiple items, the user clicks each one while pressing the CTRL key.
Usage Notes
|
Number
| A positive or negative decimal number.
Use the
Length/Decimal places field to specify how many numbers can be entered (the left box). Use the right box to enter the maximum number of digits to the right of the decimal point. If you enter 0, there are no digits to the right of the decimal point.
Numeric values display using the format of the user's locale.
If you need to format the way in which the number appears, see
Formatting Dates, Times, and Numbers .
|
Object ID
| The object ID is the ID of the object instance. For example, it identifies one of your leads. (This value is assigned to the object by your application.)
The unique parts of this dialog are discussed after this table.
. Fields that are used here and in Field Properties dialogs are discussed at the
top of this topic.
|
Object List
| An object list is a set of object IDs. An object ID is the ID of an object instance. For example, it identifies one of your leads.
A read-only object list has a limit of 100 rows, even if the query associated with uses a LIMIT clause, asking for more rows to be returned.
Other fields are discussed at the
top of this topic.
|
Percent
| A number expressed as a per cent.
Numeric values display using the format of the user's locale.
Here are some examples--each of these examples shows a number greater than 100%:
If you need to format the way in which the percent appears, see
Formatting Dates, Times, and Numbers .
|
Phone
| A field into which you can type a phone number.
|
Picklist
| A picklist field from which the user can select one row.
Usage Notes
|
Rich Text Area
| A field that will contain HTML commands as well as text. Enter this text using the HTML editor.
You cannot enter JavaScript into a Rich Text Area.
|
Text
| A control that changes the size and number of characters that the user can type text.
|
Text Area
| A control into which the user can enter text. This can display as one or more rows.
|
Time
| Select the Time field to select time from a picklist.
The field properties dialogs that are displayed are:
The output time is in UTC, and output data and time are in ISO 8601 format. For example, if you enter an input date of 2016-03-29, and use the currentTime XQuery function to get date and time values, you see the following output:
The following are sample valid Time values:
If you do not pass a time zone, Informatica Process designers assumes the time to be in UTC.
If you check 30 Minute Increments , you see a time picklist that displays hours and half hours. If it is not checked, you can enter any time value. For example, you can enter 10:37.
If you want to format the way in which the time appears, see
Formatting Dates, Times, and Numbers .
|
URL
| A field that will contain a URL.
A URL can be an input, output or temporary
process field or even a field from. The field's data is assumed to be a valid URL.
To create a button in a screen step:
|
XML
| You can use XML data type with only with an Informatica Process Designer process.
To use the XML data type in a process, you can do either of the following:
To map simple XML data elements to other fields, use formula and XQuery functions.
For example, consider the following XML:
You can use this XQuery function to search for the order number:
When you query XML data with namespaces, you must use the asterisk (*) character.
|