3.1
List
where a table is used
Sometimes you want to know if certain tables are listed in sql overrides
of Source Qualifier or Lookup transformation. This helps you identifying
dependencies. The query below will list folder, attribute type and sql override
as output.
SELECT DISTINCT REP_ALL_MAPPINGS.SUBJECT_AREA, REP_ALL_MAPPINGS.MAPPING_NAME,REP_WIDGET_ATTR.ATTR_NAME,
REP_WIDGET_ATTR.ATTR_VALUE
FROM REP_WIDGET_ATTR, REP_WIDGET_INST, REP_ALL_MAPPINGS
WHERE REP_WIDGET_ATTR.WIDGET_ID =
REP_WIDGET_INST.WIDGET_ID
AND REP_WIDGET_INST.MAPPING_ID =
REP_ALL_MAPPINGS.MAPPING_ID
AND REP_WIDGET_ATTR.WIDGET_TYPE IN (3,11)
AND REP_WIDGET_ATTR.ATTR_ID = 1
AND REP_WIDGET_ATTR.ATTR_VALUE LIKE '%' || REPLACE('TABLE_NAME', '_', '/_')
|| '%' ESCAPE '/'
ORDER BY 1,2,3
3.2
List
all source and target tables of mapping
SELECT
DISTINCT SUBJECT_AREA,SOURCE_NAME,TARGET_NAME,MAPPING_NAME FROM REP_TBL_MAPPING
ORDER
BY 1,2,3,4
3.3
List
comments of all objects
SELECT
B.SUBJECT_AREA AS FOLDER_NAME, A.OBJECT_NAME,A.COMMENTS, A.VERSION_NUMBER
FROM
REP_VERSION_PROPS
A, REP_SUBJECT B
WHERE B.SUBJECT_ID = A.SUBJECT_ID
AND A.COMMENTS IS NOT NULL
ORDER BY 1,2
3.4
List
of Database used in Repository
The database definition view provides
a list of all database definitions in the repository. A database definition includes
the source database names, flat file or RDBMS, and the folder where the
database definition resides.
select subject_area,database_name,def_source from
REP_DATABASE_DEFS
order by 1,2,3
IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.
ReplyDeleteIEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.
corporate training in chennai corporate training in chennai
corporate training companies in india corporate training companies in india
corporate training companies in chennai corporate training companies in chennai
I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai
It is a great website.. The Design looks very good.. Keep working like that!. https://www.vanityliving.com/collections/dressing-tables-dubai-uae
ReplyDelete