Time Adjustment

Specify the process the ETL tool must use to adjust the date/time values, in GMT time, to a different time zone when the values are transferred to the reporting database.

1. "local" or the time zone ID (A list of supported time zone IDs are located at http://publib.boulder.ibm.com/infocenter/sonasic/sonas1ic/index.jsp?topic=/com.ibm.sonas.doc/appx_timezones.html ).

If the time is adjusted to the Local Time: <TIME_ADJUSTMENT>local</TIME_ADJUSTMENT>

If time is adjusted to Pacific Time : <TIME_ADJUSTMENT>America/Los_Angeles</TIME_ADJUSTMENT>

If time is adjusted to China Standard Time : <TIME_ADJUSTMENT>Asia/Shanghai</TIME_ADJUSTMENT>

2. The number of hours by which the local time is ahead or behind (negative number) the GMT time.

Note: DST adjustment is not automatically executed if the number of hours is used.

For example, if the time is adjusted to Pacific Time : <TIME_ADJUSTMENT>-8</TIME_ADJUSTMENT>

If the time is adjusted to Standard Time : <TIME_ADJUSTMENT>8</TIME_ADJUSTMENT>