Jaya,
For this one it all depends on what type of attribute it is.
One way you can find what table attributes are in is to query
select * from dwh_meta_columns
dwh_meta_columns is in both the ppm as well as the dwh schema so you should be able to query it from either place.
On the ppm schema it has the attribute_code
Note that lookups usually have 2 rows in the table. One is the attribute and one ends with _caption
Here you can filter by object_code which may help.
In general:
Lookups may end up with a table name similar to the lookup ID
Multi-valued lookups end up in dwh_cmn_mv_lookups
Other string type attributes usually end up in the table similar to the name of the object.
If the attribute is in a sub object it usually ends up in the table with name similar to the parent.
------------------------------
Liz Williamson
Principal Support Engineer - Clarity
Broadcom
------------------------------
Original Message:
Sent: Jun 20, 2022 09:46 AM
From: Jaya Santosh Kumar Patchipulusu
Subject: Custom Attributes in DWH Tables - Project Object
Hi All - When we create custom attributes on Objects we refer the ODF_CA tables.
In DWH which table we will have these custom attributes?
Please advice.