Hello team.
I need a query to the database that shows me the attributes that are included in the data warehouse (custom attributes and stock attributes, all). I have this query:
SELECT DISTINCT
meta.object_code,
obj.name Objeto,
meta.attribute_code cod_atributo,
meta.dwh_table_name tabla_dwh,
meta.dwh_column_name columna_dwh,
decode(meta.is_custom,'0','No','1','Sí') personalizado
FROM
dwh_meta_columns meta
INNER JOIN
ODF_OBJECTS_V obj ON obj.code = meta.object_code AND obj.language_code = 'es'
ORDER BY
Object_code, meta.attribute_code
Result:
I can not show the "name" of the attribute:
Anyone know what table I can get it?
Thank you very much in advance.