| Informatica Data Type | Prophecy Data Type |
|---|---|
Array | array |
Bigint | bigint |
Binary | bytes |
Date/Time | date/datetime |
Decimal | decimal |
Double | double |
Integer | int |
Nstring | string |
Ntext | string |
Real | float64 |
Small Integer | int |
String | string |
Struct | struct |
Text | string |
timestampWithTZ | timestamp |
Informatica to SQL
Data type mapping to BigQuery SQL
List of how Informatica data types map to Prophecy data types in BigQuery SQL
The following tables list all the Informatica data types that Prophecy supports and the corresponding Prophecy data type it maps to in BigQuery SQL:
To learn more about the Prophecy data types in SQL projects, see Supported data types.