Page 1 of 1

basename(lookup) Hint???

Posted: Fri Sep 04, 2015 8:45 pm
by sarah
Good afternoon. Anyone have a clue what the "basename(lookup)" text in a create projection statement indicates?

For example:

CREATE PROJECTION public.retail_sales_super /*+basename(code_value),createtype(L)*/

Re: basename(lookup) Hint???

Posted: Fri Sep 04, 2015 10:09 pm
by NorbertKrupa
It's the basename of the projection. For example, a projection basename can be customer_dimension_vmart and when segmented will have _b0, _b1 appended.