Use this page to specify the parameters used by the transformer or program. This section contains information about the following controls:
Use this field as an alternative to setting an end date or time for your period table. In this field, you enter the number of period rows that the transformer will generate in the Period Table. This field is optional.
If you decide not to use this field, then the following conditions are true:
If the Generate Period Table transformer is writing to a Date column, you must select an end date in the Date field. The end date must be greater than the start date.
If the Generate Period Table transformer is writing to a Time column, you must select an end time in the Time field. The end time must be greater than the start time.
If the Generate Period Table transformer is writing to a TimeStamp column, you must select an date in the Date field and a time in the Time field. The end date and time must be greater than the start date and time.
If you do not enter a value in the Create rows field, you must enter a value or values in the Date and Time fields in the End section.
In these fields, you either specify the date or time (or both) that you want to be last date/time value entered into the period table, based on the following conditions:
If the Generate Period Table transformer is writing to a Date column, you must select an end date in the Date field. The end date must be greater than the start date.
If the Generate Period Table transformer is writing to a Time column, you must select an end time in the Time field. The end time must be greater than the start time.
If the Generate Period Table transformer is writing to a TimeStamp column, you must select an date in the Date field and a time in the Time field. The end date and time must be greater than the start date and time.
From this list, click one or more optional columns that you would like to be populated in the period table. Click the arrow buttons to add or remove a selected column.
The following table describes the available columns:
|
Column |
Data Type |
Notes |
|
Julian Day |
Integer |
Dates start January 1, 4712 B.C. |
|
Hour in Day |
Integer |
1 - 24 |
|
Day in Week |
Integer |
1 - 7 (varies by locale,
default locale used) |
|
Day in Month |
Integer |
1 - 31 |
|
Day in Year |
Integer |
1 - 366 |
|
Week in Month |
Integer |
1 - 5 (weeks in the month begin on |
|
Week in Year |
Integer |
1 - 53 |
|
Month in Year |
Integer |
1 - 12 |
|
Quarter in Year |
Integer |
1 - 4 |
|
Year |
Integer |
Nnnn |
|
Day Name |
Varchar |
Default locale used |
|
Month Name |
Varchar |
Default locale used |
|
Sequence |
Integer |
This column requires your |
|
Periodic |
Integer |
This column requires your |