I'm wondering if anyone has a list of all the tables that are populated from the Datamart Extraction Job.
This is the list that I have compiled based on my research, but I was wondering if I am missing any other tables.
The list of tables looks good.
In addition to the tables, here is a query that will give you a list of portlets that reference the NBI tables.
I used this on an Oracle database for 14.2 and it shows portlets that have queries with these tables.
If you have any user-defined queries that includes the text 'NBI' , these portlets will be listed as well.
select p.portlet_code as portlet_code,
n.name as portlet_name,
gg.query_code as nsql_code,
'grid' as portlet_type
from cmn_portlets p
join cmn_captions_nls n
on n.language_code = 'en'
and n.table_name = 'CMN_PORTLETS'
and n.pk_id = p.id
join cmn_grids g
on p.id = g.portlet_id
join cmn_gg_nsql_queries gg
on gg.cmn_nsql_queries_id = g.dal_id
and g.dal_type = 'nsql'
and g.principal_type = 'SYSTEM'
join cmn_nsql_queries q
on gg.cmn_nsql_queries_id = q.id
and upper(q.nsql_text) like '%NBI%'
'graph' as portlet_type
join cmn_graphs g