Desktop productivity for business analysts and programmers

Fact Table Lookup code generation

Reply
N/A
Posts: 0

Fact Table Lookup code generation

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?
Valued Guide
Posts: 2,111

Re: Fact Table Lookup code generation

Are you sure you are working with Enterprise Guide? "Fact Table Lookup" is not a construct in EGuide.
N/A
Posts: 0

Re: Fact Table Lookup code generation

I was working on Data Integration Studio. Sorry for placing the post in a wrong place.
Ask a Question
Discussion stats
  • 2 replies
  • 95 views
  • 0 likes
  • 2 in conversation