Fact Table Lookup code generation

deleted_user — Wed, 04 Jun 2008 13:25:56 GMT

Hello,

The Fact Table Lookup node to lookup is generating different source codes for different target tables. Sometimes it doesn't generate the following code :

/*---- Create the xref table ----*/
/* Remove any existing temporary cross reference file */
proc datasets lib = work nolist nowarn memtype = (data view);
delete tempXrefTable;
quit;

/* Sort target table */
proc sort data = pmd.FINANCIAL_ACCOUNT_DIM
out = work.tempXrefTable;
by ACCOUNT_RK VALID_TO_DTTM;
run;

%rcSet(&syserr);

/* Get the last key variable in each set of keys */
data work.tempXrefTable;
set work.tempXrefTable;
by ACCOUNT_RK;
if last.ACCOUNT_RK;
output;
run;

Does anyone know why this happens or what should I do to have my lookup target table ordered by ACCOUNT_RK VALID_TO_DTTM?

Re: Fact Table Lookup code generation

Doc_Duke — Wed, 04 Jun 2008 16:22:56 GMT

Are you sure you are working with Enterprise Guide? "Fact Table Lookup" is not a construct in EGuide.

Re: Fact Table Lookup code generation

deleted_user — Mon, 09 Jun 2008 17:40:39 GMT

I was working on Data Integration Studio. Sorry for placing the post in a wrong place.

topic Re: Fact Table Lookup code generation in SAS Enterprise Guide

Fact Table Lookup code generation

Re: Fact Table Lookup code generation

Re: Fact Table Lookup code generation