Reg: Finding Dependencies on a particular column in a table

[Anonymous]

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

[Anonymous]

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