The transformation for the time dimension insert fails due to a lack of quotes around the string values. It interprets the string value as a column name. I ran the insert statement after manually putting in the quotes ('Sunday') and it ran. I have been looking for a transformation step which will quote the string values. I can't find it. What next?

2007/11/08 10:51:04 - Table output.0 - ERROR (version 3.0.0-RC2, build 299036 from 2007/10/31 23:59:46) : Because of an error, this step can't continue:
2007/11/08 10:51:04 - Table output.0 - ERROR (version 3.0.0-RC2, build 299036 from 2007/10/31 23:59:46) : Error batch inserting rows into table [time_dimension].
2007/11/08 10:51:04 - Table output.0 - ERROR (version 3.0.0-RC2, build 299036 from 2007/10/31 23:59:46) : Errors encountered (first 10):
2007/11/08 10:51:04 - Table output.0 - ERROR (version 3.0.0-RC2, build 299036 from 2007/10/31 23:59:46) : Batch entry 0 INSERT INTO "public".time_dimension(date_key, date_value, year_value, month_value, day_of_year, day_of_month, day_of_week, week_of_year, day_of_week_desc, day_of_week_short_desc, month_desc, month_short_desc, quarter) VALUES ( 1, 1950-01-01, 1950, 1, 1, 1, 1, 1, Sunday, SUN, January, JAN, 1) was aborted. Call getNextException to see the cause.

ERROR: column "sunday" does not exist
SQL state: 42703
Character: 272