Hai Kuo I kinda figured out how PROC HPDS2 works from the reference materials that you provided. Thanks again for that. However, I see that the HPDS2 procedure works even if the destination library happens to be a Unix directory instead of a Greenplum schema. To see the performance improvement, should it be run only with a Greenplum destination or even a local destination would be sufficient? Is it the procedure or the database that does the trick w.r.t performance? Also I don't have a hold on the variables that are being used in the model. So I cannot use DCL statement with all the variable names and their corresponding types. How can that be addressed in the procedure? I am yet to apply the procedure on actual code. Just wanted to make sure of this before I start making changes to my code. Thanks.
... View more