DSXchange

Hi Guys,
Anyone know about how to remove the temporary schema generation in IBM INFOSPHERE WAREHOUSE 9.7. I am getting an error as "you does not have privilege to create schema".

Thanks

Wouldn't it make more sense to execute as a user who does have the requisite database privileges?

ya eventhough the user who has the privilege,everytime the schemas are generating and he got to remove them right instead of that if we select the option of not generating the schemas then it wouldn't be a problem.

Thanks.