topic Re: How to Avoid the Work Tables in SAS DATA INTEGRATION STUDIO? in SAS Procedures

How to Avoid the Work Tables in SAS DATA INTEGRATION STUDIO?

deleted_user — Thu, 04 Dec 2008 20:30:27 GMT

I am new to SAS DI , When i try to create the Source to Staging MAP , those temp/Work tables are automatically creates by DI which is causing the performance issue ans lot other problem when working with

My question is how can i tell DI when to have or not to have the work table,
Thanks
Oramcle

Re: How to Avoid the Work Tables in SAS DATA INTEGRATION STUDIO?

LinusH — Thu, 04 Dec 2008 21:17:34 GMT

Somtimes you can avoid them, often not. For instance some transformations can directly output to the target table, then avoiding the Table Loader. By using user written code you can also control processing more, but I don't recommend that kind of Process design, because it will undermine the benefits of what the tool is meant to do.

But I'm not that you have worry too much about performance. Most transformations allow you to define the output tables as views, and having sufficient memory will allow the steps to be performed without costly disk I/O. If you have some crucial steps where performance is a real concern, you can override the default generated in those specific situations.

Regards,
Linus

Re: How to Avoid the Work Tables in SAS DATA INTEGRATION STUDIO?

deleted_user — Mon, 08 Dec 2008 21:38:32 GMT

Thank you ,
ram