Home Flat Files rules Fixed-width flat files are byte-oriented

Fixed-width flat files are byte-oriented Featured

Written by 
Rate this item
(1 Vote)

The following is an excerpt from the Informatica "Designer Guide", "Working with Flat Files" manual:

"(...) Fixed-width flat files are byte-oriented, which means that the field lengths are measured in bytes. They can also be line sequential, which means each row ends with a newline character. You can import a fixed-width file that does not contain binary data or multibyte character data greater than two bytes per character. (...)"

This means that when one defines in the source that one's field is string 20, that string has 20 bytes (not characters). Thus, in case of UTF-8, some characters are single byte like "a" and some are multibyte, like "ą", which is 2 byte in length. Even with having a fixed number of 20 characters in UTF-8, your field would still have a different size in terms of bytes. Bear in mind that the source you defined has a fixed size in bytes.



Read 5822 times