Symptom
- You need to send the SQL in your SQL Transform to a different schema then what the Datastore points to
- Your Datastore may have 'Alias' set up but this not affecting which schema the SQL transform sends it's query to - Alias works only for source tables
- The SQL in your SQL Transform does not contain any references to schema / table owner
Read more...
Environment
- Data Services
- Oracle
Product
SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2
Keywords
BODS, BODI, DS, DSXI, Edge , KBA , EIM-DS , Data Services , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.