If the lookup_id contains a space the Load Data Warehouse fails with the following error:
CREATE_LKP_TAB - org.pentaho.di.core.exception.KettleStepException:
Error while running this step!
And referencing your table:
Couldn't execute SQL: CREATE TABLE DWH_LKP_YOUR TABLE_00
This is caused by a space in the Lookup_id.
In general PPM does not allow for spaces or special characters in the ID, but there have been occasions where this did happen.
Either do not include the attribute in the data warehouse or if you do need it in DWH then you will need to create a new lookup and attribute and then move values from the old attribute to the new one.