On the Parameters page, in the Resolution list, click the resolution for the date, time, or timestamp column for the period table.
Specify the starting period value by clicking either the date or time check boxes, or both. Then, set your starting date or time (or both):
-
To create a period table with a column that has type Date, click the Date check box. Then, click
.
A calendar is displayed. use the << and >>
buttons to scroll through the months on the calendar. After you find
your start month, click a date in the calendar. -
To create a period table with a column that has type Time, click the Time check box. Then, click either the hours, minutes, or seconds in Time field, and use the arrow buttons to specify your time.
-
To create a period table with a column that has type TimeStamp, click both check boxes and specify a start date and a start time.
Specify the ending period value using the number of rows or using an ending date and time or both:
-
To specify the total number of period rows to generate, click Create rows and type the number of period rows in the Create Row field. This field is required when this option is selected.
-
To specify the ending period using a date and time or both, click Create end date or time and select a date or time or both in the Date and Time fields.
Optional: In the Available Columns list, click one or more columns to create period related data. Then, click >. The columns are moved to the Selected columns list.
If you placed Sequence Number in the Selected columns list, type a numeric starting sequence value in the Starting value field. Then, type a numeric increment value in the Increment value field.
If you placed Period number in the Selected columns list, type a numeric starting period value in the Starting value field. Then, type a numeric repeat value in the Repeat value field. Next, type a numeric increment value in the Increment value field. Finally, type a numeric cycle value in the Cycle value field.
If your step is not already linked to a target and you would like the Data Warehouse Center to create a target table for this transformer, click Create warehouse target table based on parameters.
If you clicked Create warehouse target table based on parameters, from the Warehouse target list, select the name of the warehouse target where you want the Data Warehouse Center to create the table.