Reg: Finding Dependencies on a particular column in a table

Anonymous — Tue, 23 May 2017 23:37:13 GMT

Hi,

I have a table, in that I have few columns. I want to know list of mappings where these columns are used.

Eg: I have a table EMPLOYEE, in that I have columns named EMPNO, ENAME, DEPTNO, SAL, COMMISSION. As part of impact analysis, I want to know list of maapings where ENAME was used.

To achieve this, I went to METADATA, went to the required table, right click on that, you will find an option "Impact Analysis". I clicked on that and provided tablename and column name. However I don't see any list. Could you please let me know whether anything is missing here?

Thanks,

Durga devi

Re: Reg: Finding Dependencies on a particular column in a table

Anonymous — Wed, 31 May 2017 09:41:55 GMT

First, make sure there exists job read this table.
Click the 'Impact Analysis' item, it will open the Impact Analysis viewer, for example

Regards
Shong

topic Reg: Finding Dependencies on a particular column in a table in Data Quality

Reg: Finding Dependencies on a particular column in a table

Re: Reg: Finding Dependencies on a particular column in a table