Control Datastore where the optimized sql will run on BODS

[Former Member]

Is there is any way to control the data store where the optimized sql will run on BODS?

The optimised sql should have run on a schema A of the database, but the optmised sql is running on the Scheme B. Is there is any way in order to make the optmised sql to run on schema B.

[former_member200473]

Hi Arun,

please check which schema you have selected for datastore.

Regards,

Shiva Sahu

[Former Member]

Actually in my scenario there are 4 tables from schema A corresponds to datastore A and 1 table from schema B corresponds datastore B as the source. My target table is in datastore B (schema B). The insert query developed by DS is in datastore B, but I need change that to datastore A. Is there is an option for this?

[former_member200473]

Hi Arun,

if i got you right,you can use Data_Transfer Transform right before the target table and use the table as transfer type (you can select datastore for selecting for table).

if i was not clear to you ,could you please specify your logic/ requirement you are trying to implement.

Regards,

Shiva Sahu

[Former Member]

Thanks Sahu for the response. Your answer was helful. My problem is that I am doing a migration from BODI and BODS and number of code changes should be minimal.

My actual requirement is to change the datastore where query the run without adding transforms or changing the code, like if we can change the datatore in the Vaildate SQL option or something like that.

But I understoood that is not possible. Anyway your suggestion was really good.

Thanks

[former_member200473]

Hi Arun,

Thanks for your appreciation .

If you don't want to change the code ,you can use database link concept.

You can find it very easy and it will work.

let me know if your work has not been done and you don't find any relevant document for the same

Regards,

Shiva Sahu

[krscheffler]

Hi Arun,

I am moving this discussion to the DS area of SCN.

Thanks,

Kristen