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
I can not show the "name" of the attribute:
Anyone know what table I can get it?
Thank you very much in advance.
You need to join with the CMN_CAPTIONS_NLS table to get the name. Don't forget to specify the language value ('en' if you want english) to keep your result set under control.