Flat file data types and transformation data types
Flat file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the Hadoop Files flat data types that the Secure Agent supports and the corresponding transformation data types:
Flat File Data Type
Transformation Data Type
Description
BigInt
BigInt
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision of 19, scale of 0
Number
Decimal
Precision 1 to 28 digits, scale 0 to 28
Nstring
Text
1 to 104,857,600 characters
Fixed-length or varying-length string.
STRING
String
1 to 104,857,600 characters
Default precision is 256. You can increase the value up to 104857600 characters.
Note: You can read or write BigInt, Number, and Nstring data types only when you select Import from Schema File as the Schema Source in the file formatting options.