Fact Table Lookup code generation

[deleted_user]

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?

[Doc_Duke]

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

[deleted_user]

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