Solved: Re: SAS DI Studio jobs

Micheal_S · Posted 05-29-2018 04:21 AM

Hello,

I have a question -

My SAS DI has about 100+ jobs and most of them are using tables from a particular schema (Oracle), Now suppose if i drop the tables and create views with the same name as tables and same structure, so do i need to make any changes to jobs also? or they will pick views automatically during execution time?

Please provide views.

Regards,

Mike

RLigtenberg · Posted 05-29-2018 02:58 PM

I tested this on a local SAS/Oracle installation with an existing DI Studio job that reads Oracle tables. I dropped the tables in Oracle and replaced them with same-named views in Oracle. After the change the job completed successfully without changes to the job or to the Oracle table metadata. The job I tested has a Join transformation and is set for implicit pass through (Pass Through = No).

YMMV.

View solution in original post

RLigtenberg · Posted 05-29-2018 02:58 PM

I tested this on a local SAS/Oracle installation with an existing DI Studio job that reads Oracle tables. I dropped the tables in Oracle and replaced them with same-named views in Oracle. After the change the job completed successfully without changes to the job or to the Oracle table metadata. The job I tested has a Join transformation and is set for implicit pass through (Pass Through = No).

YMMV.

Micheal_S · Posted 05-31-2018 06:37 AM

Great. Thanks Robert