Generate attribute definition extract

[datamart]

Hi,
I require an extract that gives me all the attributes, their ID, DESC definitions, and atleast the lookup source table. Is there a better way to get this extract other than manually editing each attibute and noting down the details. Can we use Command Manager for the same.

Please respond...

Thanks.

 

[mizh]

Desktop -> Schema -> Export Project Schema.

Check 'Attribute Definitions' and 'Table Catalog - Logical View'. You will need to reconcile the two sheets.

You can also pull what you need from the metadata DB tables (DSSMDOBJINFO/DSSMDOBJDEPN) using SQL.