They also provide the ability to perform arithmetic and rounding on data as it
is converted. You create one conversion file per dimension in a transformation. Each conversion file can contain one or more sheets for different types of data transformations.
OPTIONS:
FORMAT = DELIMITED
There is no default so this option must be defined. You must enter a format type. Delimited means that there is a special character between each column of data, defined by the Delimiter option (below). Fixed means that the data is in a fixed field format.
HEADER
Default: YES If YES, then your input file contains one header row that defines the fields.
DELIMITER can be COMMA | SPACE | TAB Default:, (comma) If the FORMAT option is set to DELIMITED, this option defines the single character that is the delimiter between columns. Use the keywords SPACE or TAB if space or tab-delimited.
SKIP = Default: 0 (zero) Number of lines to skip at the top of a data file. If your data file has a header, set this value so that thoselines are skipped during transformation. SKIPIF = NULL will skip a record is it null.
VALIDATERECORDS = No | Yes Default: No If YES, validate the mapping and that members exist, and map data in the proper order for BPC.
CREDITPOSITIVE = Default: YES, If Yes, all amounts referring to an ACCOUNT type (LEQ, INC) will have their signs reversed.
MAXREJECTCOUNT = The number of bad records before the entire load fails.
ROUNDAMOUNT =