Defining Periods in a Quick Mode - File-Based Load
Period processing for Quick Mode - file-based loads do not use the periods defined in
the Period Mapping option. Instead, periods are handled like any other dimensions
and can be derived from the header record in the source file. If there is no Period
and Year header record in the source file, you are prompted for the start and end
period when you run the load during execution in which case all the data is loaded
to the single period. Another option is to derive the period dimension based on the
source system period name from the header record using the toPeriod
and toYear
target expression types to a specific format. Other
target expressions that can be used for the Period dimension include
substring()
, split()
, and
map()
.